Ecommerce software home
Shopping Cart Software Forum for Ecommerce Templates
 
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

Find us on Facebook Follow us on Twitter View our YouTube channel
Search our site
 All Forums
 Technical
 PHP (Unix / Linux / Apache) versions
 Database utility syntax error
Author « Topic »  

John M
Advanced Member

457 Posts

Posted - 07/26/2021 :  04:31:19  
Just updated the server to the following:

MySQL Version: 8.0.26
PHP Version: 7.3.24
Ecommerce Plus PHP v7.4.1

And received this error in the database utility:

OPTIMIZING TABLE
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use

Has OPTIMIZE been deprecated for MySQL?

John

Vince
Administrator

42474 Posts

Posted - 07/27/2021 :  00:34:50  
Hi John
It seems, looking at that, that there is a table with a blank table name for some reason and that is why the error. I'll put a check for blank names in the next updater so it should cure that.

Vince

Click Here for Shopping Cart Software
Click Here to sign up for our newsletter
Click Here for the latest updater
  « Topic »  
Jump To:
Shopping Cart Software Forum for Ecommerce Templates © 2002-2022 ecommercetemplates.com
This page was generated in 0.02 seconds. Snitz Forums 2000