Welcome to Geeklog, Anonymous Saturday, December 21 2024 @ 01:33 pm EST
Geeklog Forums
Upgrade from 1.3.9 won't work - table already exists error
GuyDorey
Anonymous
Hi, I've been using 1.3.9.sr1 very happily for a while but thought it was time to upgrade. I followed the upgrade instructions to the letter but when I click 'Next' after selecting the version number and Upgrade Database option, I get "1050: Table 'gl_spamx' already exists". I tried erasing then recreating the database from a backup, and the same problem occurs. Any help would be much appreciated!
10
9
Quote
Status: offline
Dirk
Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
Hmm, the original Spam-X plugin didn't use a table - so where did that come from?
You can either delete your Spam-X table (the install script will create a new one) or you can comment out the line in sql/updates/mysql_1.3.9_to_1.3.10.php that attempts to create that table ...
bye, Dirk
You can either delete your Spam-X table (the install script will create a new one) or you can comment out the line in sql/updates/mysql_1.3.9_to_1.3.10.php that attempts to create that table ...
bye, Dirk
11
9
Quote
GuyDorey
Anonymous
Dirk - Thanks for the tip! I erased the gl_spamx table and went through the install procedure again, and everything seems to be in order. Thanks for the quick response and top software!
9
10
Quote
All times are EST. The time is now 01:33 pm.
- Normal Topic
- Sticky Topic
- Locked Topic
- New Post
- Sticky Topic W/ New Post
- Locked Topic W/ New Post
- View Anonymous Posts
- Able to post
- Filtered HTML Allowed
- Censored Content