Welcome to Geeklog, Anonymous Saturday, March 22 2025 @ 09:29 am EDT
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!
11
12
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
12
12
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!
12
12
Quote
All times are EDT. The time is now 09:29 am.
- 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