Webmastersite.net
Register Log In

Error during updgrade
mysqli php error after updgrade error

Comments on Error during updgrade

DusX
Member

Usergroup: Customer
Joined: Jan 11, 2006
Location: Canada

Total Topics: 7
Total Comments: 24
DusX
Posted Mar 22, 2007 - 2:37 PM:

During upgrade I am getting this error:

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 'SET validatedemail='1' WHERE deleted=0 AND validated=0' at line 1

Now I have tried this a couple times, each time restoring my site to how it was.

I also get the message: Upgrade complete
if I check any of my pages, I have this error:

Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in /home/darkfash/public_html/databases/mysqli.php on line 18

in the case of my admin I can't view anything.
My public site loads, but with the same error at top.

I am going to restore my site once again, since the update is not working.
I am moving from 3.3.4 to 4.0.21

anyhelp would be great.
attached is a pdf of the debug during upgrade.

thanks

Attached Files:
Paul
developer

Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California

Total Topics: 61
Total Comments: 7868
Paul
Posted Mar 22, 2007 - 5:11 PM:

It says the problem is with the calendar table, so check your config.php. If it has
$caltable = 'wsnlinks_calendar';
, then delete that part and re-run the upgrade.
Search thread for
Download thread as
  • 0/5
  • 1
  • 2
  • 3
  • 4
  • 5



This thread is closed, so you cannot post a reply.