A Forum With ICO -- Need Help Here

I'm trying to get a working installation of ico on my board, but I need a table.

Is there any chance someone with ico installed in their forum can
give me a copy of the table in their database.

All I need is the table called "icc_queue"


You can download it via phpmyadmin or whatever exporting method you utilize.

Thanks in advanced.

 

CREATE TABLE icc_queue (queueid int(11) unsigned NOT NULL auto_increment, questionid varchar(64) NOT NULL default '', forumid smallint(5) default '0', topicid mediumint(8) NOT NULL default '0', answersavailable smallint(5) default '0', answersused smallint(5) default '0', datetopicstarted date NOT NULL default '0000-00-00', status tinyint(1) default '0', PRIMARY KEY  (queueid)) TYPE=MyISAM; 

Code (markup):

run this in phpmyadmin to create icc_queue table

 

Thanks a lot, I'll give this a try.

 

Hey, it is asking me for the number of fields.

Should I set it to 1 or a higher number?

 

I am not with ico or i own a copy of icoContent so i can not help you much

if you want to uninstall icoContent, you can use this query to Uninstall it and try reinstalling it

ALTER TABLE forum DROP icc_enable;
ALTER TABLE forum DROP icc_tags;
ALTER TABLE forum DROP icc_dayrate;
DROP TABLE icc_queue;

Code (markup):

Please take backup before you run it it will remove all icc tables and you should be able reinstall the mod from admincp (xml installation)

 

Oh ok thanks.

I'll try this instead.

I tried to uninstall and ran into some problems.

I'll do a backup and then try this.

Cheers.

 

the above code i provide should remove all the tables from icc. When you try to reinstall from vBulletin.

When importing XML in vBulletin AdminCP, Choose "YES" TO Allow Overwrite

Hopefully everything run smooth after. If it does not you tell what is exact error you are getting may be i can look into for you

 

Hey, is DROP the same as deleting a table from the database?

Reason I ask is because yesterday, I deleted an icc table and my board ran into some minor problems. Fortunately, I was upgrading so it was an easy fix.

I deleted "icc_enable" without dropping it.

Should I drop tables and not delete them?

 

itdevil,

Thanks a lot, this worked!

 

Delete / Drop is the same thing.

You just need remove 4 tables from you database so when you run the XML it does give duplicate error.

Edit:-

Great Glad to be of assistance.

Have a great day.