| Re: How to upgrade from 2.0.11 to 2.0.13 |
| by THCowboy on 2006/7/25 1:59:17 that was it.... now it works thanks for all your help. very much appreciated
|
| Re: How to upgrade from 2.0.11 to 2.0.13 |
| by Lance_ on 2006/7/25 1:33:44 It's all in the details. Notice the quote isn't the same in the drop table line as the one in teh create table line. If you copied the line from my post above, I probably used the wrong quote. Just use the one from your file. le="color: #000000"><?php DROP TABLE IF EXISTS `xoops_bb_archive`; This should do it.
|
| Re: How to upgrade from 2.0.11 to 2.0.13 |
| by THCowboy on 2006/7/25 1:24:17 now I get this #1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ''xoops_bb_archive'' at line 1 whats up.... about to lose it LOL here is what I have le="color: #000000"><?php -- -- Table structure for table `xoops_bb_archive` -- DROP TABLE IF EXISTS 'xoops_bb_archive'; CREATE TABLE `xoops_bb_archive` ( `topic_id` tinyint(8) NOT NULL default '0', `post_id` tinyint(8) NOT NULL default '0', `post_text` text NOT NULL ) TYPE=MyISAM; -- -- Dumping data for table `xoops_bb_archive` --
|
| Re: How to upgrade from 2.0.11 to 2.0.13 |
| by Lance_ on 2006/7/25 1:12:46 LOL, almost like mindreading. |
| Re: How to upgrade from 2.0.11 to 2.0.13 |
| by THCowboy on 2006/7/25 1:11:30 ok.... I think it is because I forgot the ; at the end of the new line
|