problem to go through "determine type of install"

New Member Joined: Apr 30, 2004 Posts: 4

env: phpnuke 7.2+mysql

status: "Great! I was able to connect to the database"

problem: pressed botton "Determine Type of Install" without changing "kissq_portfolio" and got this:

"Welcome to the KISSQ MySQL Table Installer!
Unable to Select the database. Please check your information on the previous page.

You have an error in your SQL syntax near '-_db like 'kissq_portfolio'' at line 1 "

BTW, my datebase's name is not nuke. prefix=nuke

thx a lot!

Site Admin/Owner Joined: Aug 27, 2002 Posts: 17088

I need to know the name of your database to try to see if there is a problem. This has been installed on thousands of sites without any issues so either there is a problem with your setup or something really wierd is happening Smile

. You can PM me the name if you want.

Posted: Fri Apr 30, 2004 7:16 am

name of database: invester178_com_-_db

Posted: Fri Apr 30, 2004 7:42 am

Well guess what? It appears the -db gives MySQL a migraine when issuing the Show tables command and probably all server commands. Try surrounding your database name with backward tick marks `DB_NAME`. If that doesn't work then modify the kissq-sql.php file. On or about line 63 modify this code

Code:

elseif ($action=="Determine Type of Install") {


   $query = "show tables from $database like '$kissqTable'";

to

Code:

elseif ($action=="Determine Type of Install") {


   $query = "show tables from `$database` like '$kissqTable'";

Posted: Fri Apr 30, 2004 9:16 am

changing name of database doesn't work.
change code is OK.

did I tell u nice job? Thx a lot.

Posted: Fri Apr 30, 2004 9:57 am

- I will update the installer. Evidently not many people name their databases with a -.

Posted: Fri Apr 30, 2004 10:53 am

the name of database is recommended by host provider. we can do nothing with it.

Posted: Fri Apr 30, 2004 10:54 am

As I said in my IM to you, I will be contacting the MySQL folks to see what's going on. Thanks.