| |
Haven't registered yet? Do it here now!
|
scuzz
Joined: 23 Jun 2007
Posts: 23
|
|
|
 |
|
 |
|
 Posted: Thu Jun 30, 2011 2:48 pm Post subject: Upgrade failed. MYSQL errors |
 |
|
|
 |
|
 |
|
|
|
|
Upgraded from 1.6 or so to 1.7 on one site, and no problem.
Tried it on the next site and the lo-upgrade script says
"....... Query to MySQL Failed: Unknown column 'acceptemail' in 'field list'"
and stalls.
After that, I can get into the admin but all I get is a bazzilion mysql errors.
For Instance: Total Invisible Trades: Query to MySQL Failed: Unknown column 'invisible' in 'where clause'
Query to MySQL Failed: Unknown column 'ipaddr' in 'field list'
Etc. The script no longer works as expected. What to do?
I'm using PHP Version 5.2.14 |
|
|
|
|
|
|
|
Atanasis
Owner
Joined: 22 May 2004
Posts: 4284
Location: The Net
|
|
|
|
|
|
|
| Posted: Thu Jun 30, 2011 3:16 pm Post subject: |
|
|
|
|
|
|
|
|
|
|
did you forget to run the lo-upgrade.php file after uploading the upgrade package?
_________________
Thanks,
Kaktusan
 |
|
|
|
|
|
|
|
scuzz
Joined: 23 Jun 2007
Posts: 23
|
|
|
|
|
|
|
| Posted: Thu Jun 30, 2011 6:51 pm Post subject: |
|
|
|
|
|
|
|
|
|
|
Like I said in the 1st post:
| Quote: | the lo-upgrade script says
"....... Query to MySQL Failed: Unknown column 'acceptemail' in 'field list'"
and stalls. |
|
|
|
|
|
|
|
|
Atanasis
Owner
Joined: 22 May 2004
Posts: 4284
Location: The Net
|
|
|
|
|
|
|
| Posted: Thu Jun 30, 2011 9:50 pm Post subject: |
|
|
|
|
|
|
|
|
|
|
ah, sorry, mislooked that..
weird.. never had problems with the upgrade file..
I will need the following info to go looking and fixing it:
url and pass to LO admin
ftp access
phpmyadmin access
you can pm it to me
_________________
Thanks,
Kaktusan
|
|
|
|
|
|
|
|
scuzz
Joined: 23 Jun 2007
Posts: 23
|
|
|
|
|
|
|
| Posted: Fri Jul 01, 2011 5:24 pm Post subject: |
|
|
|
|
|
|
|
|
scuzz
Joined: 23 Jun 2007
Posts: 23
|
|
|
|
|
|
|
| Posted: Fri Jul 01, 2011 11:01 pm Post subject: |
|
|
|
|
|
|
|
|
|
|
Hah! Your idea was dead on. I just went into the PhpMyadmin and gave that particular user all privileges.
I then ran the script and it upgraded just fine.
Usually on a server I only have one user and never realized that he had several on there.
I can't thank you enough for your help as I would have been pounding my head against a wall forever
trying to figure it out, So again,
Thank You!
Great Support! |
|
|
|
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
Powered by phpBB © 2001, 2002 phpBB Group
|
 |
|
 |
| |
