Jump to content
View in the app

A better way to browse. Learn more.

The Uniform Server Community

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Newbie: SQL error on install of SMF forum

Featured Replies

I get the error:

 

Some of the queries were not executed properly. This could be caused by an unsupported (development or old) version of MySQL.

 

Technical information about the queries:

Line #563: 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 '(14) /*!40102 NOT NULL default CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP */,' at line 3

Click here to try this step again.

 

I am using Uniform Server 5.7.4-Nano

and MySQL 5.5.9

 

In the past I have never had an issue like this.

 

Any ideas?

No ideas. Not enough info to form an opinion, either.

 

Need to see line #563 and surrounding 10 (or-so) lines. That way we can check the syntax. Oh, and also the first 10 lines of the file as well.

I assume this is an SQL export file of another DB?

 

BTW, MySQL 5.5.9 is not "old" in this sense. That's just a catch-all error msg.

Regards,

BobS

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

Account

Navigation

Search

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.