Home› General support

SQL Error when upgrading to 1.1.3

jean Member
in General support
Hi all,

I just finished to update zenphoto from 1.1.2 to 1.1.3 and when I run setup.php:
the last line said:
Error, could not list tables MySQL Error: 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 '.palazuelos LIKE 'zen%'' at line 1

So what did happen?
What can I do now to fix?

THX
Jean

Comments

  • sbillard Member
    Most likely you have special characters in your database name. You can download the nightly build as it has this problem corrected.
  • jean Member
    OK THX
    And very good Job for this version!
  • jean Member
    after installing nightbuild and run setp.php , I have this new message:

    Warning: DB Error, could not list tables MySQL Error: Incorrect database name 'jean.palazuelos'

    and this my correct database name ...
    is the point doing the probleme? What do you think ?

    I clicked to "Go" and no problem occurred.
    Everything seems to be OK...
  • sbillard Member
    For some reason your mySQL is not allowing the query to list the database tables. That is not too much of a problem (thus the warning). Setup will just try to recreate the tables each time it runs. This is harmless as they won't be created if they already exist, but it is a waste of time which is why setup tried to see what existed.

    You can check your mySQL configuration and see if there is something blocking the query. Perhaps you can ask your service provider as well. Otherwise you will continue to get this warning when you go from release to release.

    I think that sometimes there are problems when special characters are in database names. The installation on my service provider will allow only alpha, numbers, and underscore as characters in the database name. Must start with alpha.
  • trisweb Administrator
    The database names should be enclosed in backticks (``database-name``), are we doing this? It allows for all valid database names to be used.
  • sbillard Member
    They are in the nightly build which is what jean is running. (See my initial response.)
  • trisweb Administrator
    Cool, thanks. Yes, in general database names should be fairly generic. Jean, you might simply have the wrong database name in the zp-config.php file?
  • sbillard Member
    Tris:

    Since this is happening in the Setup systems check, we have connected to the database as part of the check. This error is comming from after the check where setup is quering the database for what tables it has to see which tables need to be created and which just need update.

    We don't get here unless the check successfully got through to the database, so I think it must be the correct name. Something is keeping the query on the tables from working and mySQL is saying that the database name is incorrect.

    I have no idea what could cause that.
Sign In or Register to comment.