can't import table query_log
November 26, 2015 02:22PM
Hello,
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.php
--------------------
<?php
$database = "sphider";
$mysql_user = "root";
$mysql_password = "LasVegas";
$mysql_host = "192.0.0.129";
$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";
}
?>

install.php
---------------

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);
}
Tec
Re: can't import table query_log
November 26, 2015 03:37PM
http://www.sphider.eu/forum/read.php?2,20859,20868#msg-20868

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

Click here to login