There seem to be some SQL syntax and other problems that I (and others) are having with 1.3.2 and which are related to the version of the mySQL server. First there was the "SQL_MODE" var problem (see other topic in this section); when I fixed that, it got farther but bombed out on another SQL syntax error with a message implying a version issue.
Running phpinfo only shows the mysql API version (5.0.67), which is not the same as the server version. I added a mysqli_get_server_info call to my phpinfo.php and found that my local server (which works) is running 5.0.27, but my web host is running 4.0.27. That must be the problem. Anyone concur?
Never mind! I realized that I was trying to reuse an old, empty database that had been created under mySQL 4. My web host allows me to specify a version 4 or 5 when creating a new database, so that's what I'm doing right now.
Who is online
Users browsing this forum: No registered users and 8 guests
