• Registered: 2019-03-08
  • Posts: 4

Topic: MySQL Error when attempting to run db_update.php

I am using MySQL 8.0.15

When I try to run db_update.php, I get the following error:

Database reported: 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 'groups ADD g_moderator TINYINT(1) NOT NULL DEFAULT 0 AFTER g_user_title' at line 1 (Errno: 1064).

Failed query: ALTER TABLE groups ADD g_moderator TINYINT(1) NOT NULL DEFAULT 0 AFTER g_user_title

The error occurred on line 374 in C:\WebSite\Forum2\include\dblayer\mysqli.php

Is this because PunBB cannot be used with MySQL 8.0.15?

  • From: Siberia
  • Registered: 2013-08-05
  • Posts: 408

Re: MySQL Error when attempting to run db_update.php

https://dev.mysql.com/doc/refman/8.0/en/keywords.html

GROUPS (R); added in 8.0.2 (reserved)

Probably the name of the table is the same as the word reserved.
I suggest to add the prefix to all table names and add it to config.php too.

ForkBB
I speak only Russian  :P

Visman's Website

3 Reply by Jeffrey (edited by Jeffrey 2019-03-08 19:21)

  • Registered: 2019-03-08
  • Posts: 4

Re: MySQL Error when attempting to run db_update.php

Yep that sorted it thanks, and it says it upgraded the db, but now im stuck in a loop where I try and browse to the forum and i still hit the page telling me to upgrade the db, so I go to do that and it says its already upgraded

  • Registered: 2019-03-08
  • Posts: 4

Re: MySQL Error when attempting to run db_update.php

Turns out the upgrade loop was due to cached pages in the cache folder, clearing the cache folder did the job.