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!
 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
 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!
 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