XOOPS 
Forum
Forum Index General Forums Community Support Modules Support Themes Support Development International Support Module Hack Reviews Theme Designer Talk
  1. Board index / 
  2. XOOPS Community Support forums / 
  3. Installation Troubleshooting 
  4.  / How to upgrade from 2.0.11 to 2.0.13
Register
11
THCowboy
Re: How to upgrade from 2.0.11 to 2.0.13

  • 2006/7/25 0:22

  • THCowboy

  • Just popping in

  • Posts: 84

  • Since: 2005/6/28


Ok I uninstalled the newbb completly so there was nothing left of it in the database. Then I reinstalled newbb2 and then imported my old newbb2 db but I get this error.


Resized Image
12
Lance_
Re: How to upgrade from 2.0.11 to 2.0.13

  • 2006/7/25 0:39

  • Lance_

  • Home away from home

  • Posts: 983

  • Since: 2004/1/12


You can't create a table that already exists.

Just before the line
CREATE TABLE 'xoops_bb_archive' add the line
DROP TABLE IF EXISTS 'xoops_bb_archive'.

NOTE: you'll need to do this step for each table.

GDL-Web.com :: Website development.
Xoopslance.com::Freelancing and Projects
thelionsden-arena.net:: Clan/League/Ladder Hosting
13
THCowboy
Re: How to upgrade from 2.0.11 to 2.0.13

  • 2006/7/25 0:58

  • THCowboy

  • Just popping in

  • Posts: 84

  • Since: 2005/6/28


A side note - I noticed tha last time I uninstalled it said it couldn't uninstall the archive table. But I can't see it in the database.

Anyhow I reinstalled the module and did what you said but got this now

Resized Image
14
Lance_
Re: How to upgrade from 2.0.11 to 2.0.13

  • 2006/7/25 1:11

  • Lance_

  • Home away from home

  • Posts: 983

  • Since: 2004/1/12


At the end of the drop table line you have a semicolon right? You need this at the end of each instruction.

DROP TABLE IF EXISTS 'xoops_bb_archive';
GDL-Web.com :: Website development.
Xoopslance.com::Freelancing and Projects
thelionsden-arena.net:: Clan/League/Ladder Hosting
15
THCowboy
Re: How to upgrade from 2.0.11 to 2.0.13

  • 2006/7/25 1:11

  • THCowboy

  • Just popping in

  • Posts: 84

  • Since: 2005/6/28


ok.... I think it is because I forgot the ; at the end of the new line
16
Lance_
Re: How to upgrade from 2.0.11 to 2.0.13

  • 2006/7/25 1:12

  • Lance_

  • Home away from home

  • Posts: 983

  • Since: 2004/1/12


LOL, almost like mindreading.
GDL-Web.com :: Website development.
Xoopslance.com::Freelancing and Projects
thelionsden-arena.net:: Clan/League/Ladder Hosting
17
THCowboy
Re: How to upgrade from 2.0.11 to 2.0.13

  • 2006/7/25 1:24

  • THCowboy

  • Just popping in

  • Posts: 84

  • Since: 2005/6/28


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

-- 
-- 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`
--
18
Lance_
Re: How to upgrade from 2.0.11 to 2.0.13

  • 2006/7/25 1:33

  • Lance_

  • Home away from home

  • Posts: 983

  • Since: 2004/1/12


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.

DROP TABLE IF EXISTS `xoops_bb_archive`;


This should do it.
GDL-Web.com :: Website development.
Xoopslance.com::Freelancing and Projects
thelionsden-arena.net:: Clan/League/Ladder Hosting
19
THCowboy
Re: How to upgrade from 2.0.11 to 2.0.13

  • 2006/7/25 1:59

  • THCowboy

  • Just popping in

  • Posts: 84

  • Since: 2005/6/28


that was it.... now it works thanks for all your help.


very much appreciated
« 1 (2)

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

340 user(s) are online (249 user(s) are browsing Support Forums)

Members: 0

Guests: 340

more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Nov 30
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits