Welcome to Geeklog, Anonymous Tuesday, April 16 2024 @ 10:57 pm EDT

Geeklog Forums

Database Backup


Status: offline

alb3rt

Forum User
Regular Poster
Registered: 10/30/06
Posts: 71
Location:Mexico City
Hello,

En 2 sites with GL 1.8.1, I have this mistake when I use the database backup script, :

Text Formatted Code

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 'TYPES' at line 1. SQL in question: SHOW TABLE TYPES
 


Previously had no problems, I don't know if MSQL was updated.
D Web Studio - www.d-webstudio.net
 Quote

Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
That's one of the problems Geeklog 1.8.1 has with MySQL 5.5, so your hosting provider probably updated MySQL.

You can fix this in admin/database.php: Search for "SHOW TABLE TYPES" and replace it with "SHOW STORAGE ENGINES".

bye, Dirk
 Quote

All times are EDT. The time is now 10:57 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