Welcome! Log In Create A New Profile


can't import table query_log

Posted by devkbsc 
can't import table query_log
November 26, 2015 04:22PM
I am 1 day old to this tool.
Although the mysql and php versions are not compatible. I have changed my files 'database.php' and 'install.php' to mysqli. What i did that i have executed the file install.php. All the tables are imported succesfully except the query_log. I have tried in so many ways. I cant succed.

I could see that i can't attach files here. So i paste my code here

$database = "sphider";
$mysql_user = "root";
$mysql_password = "LasVegas";
$mysql_host = "";
$mysql_table_prefix = "sp_";

$conn = mysqli_connect($mysql_host, $mysql_user, $mysql_password, $database);

if (!$conn) {
die("<b>Cannot connect to database, check if username, password and host are correct.</b>"winking smiley;
} else {
print "Connection ok";


mysqli_query($conn,"create table `".$mysql_table_prefix."query_log` (
query varchar(255),
time timestamp(14),
elapsed float(2),
results int,
key query_key(query))"winking smiley;

if (mysqli_errno($conn) > 0) {
print "Error: ";
print mysqli_error($conn);
print "<br>\n";
$error += mysqli_errno($conn);
Re: can't import table query_log
November 26, 2015 05:37PM

Re: can't import table query_log
November 30, 2015 01:14AM
thank you for the reply!
Sorry, only registered users may post in this forum.

Click here to login