Search found 97 matches

by captquirk
Wed Dec 12, 2018 11:57 pm
Forum: Sphider Help
Topic: Updating Error
Replies: 37
Views: 752

Re: Updating Error

To set the version number to reflect what you REALLY have, run this from the admin folder:
$settings_dir = "../settings";
require "$settings_dir/database.php";

$db->query(
"UPDATE `".$mysql_table_prefix
."settings` SET version_nr='2.2.0-PDO' WHERE id = 1"
);
by captquirk
Wed Dec 12, 2018 11:48 pm
Forum: Sphider Help
Topic: Updating Error
Replies: 37
Views: 752

Re: Updating Error

Okay. The scenario is that you have Sphider in stalled into a directory name "sphider". In you settings, English is set as the language, so when 'sphider/search.php' is used, the language is English. Now you want to also present a search option in Spanish. Create a directory named 'es_search'. The n...
by captquirk
Wed Dec 12, 2018 4:18 pm
Forum: Sphider Help
Topic: Updating Error
Replies: 37
Views: 752

Re: Updating Error

I am curious... did it connect with the old 1.3.5 db or the newly created one? If it is the newly created one, the version number should be updated. If you don't? Absolutely no big deal at all until sometime in the future if you ever decided to do an upgrade to the next version (whenever that will b...
by captquirk
Tue Dec 11, 2018 11:23 pm
Forum: Sphider Help
Topic: Updating Error
Replies: 37
Views: 752

Re: Updating Error

The first half of your combo connects to the database. That is pure mysqli. Quite logical that you get a connection. There is no query using this connection, so just from this I can't tell if that connection is useful. The second half of your combo also connects to the database, AND the following qu...
by captquirk
Tue Dec 11, 2018 9:59 pm
Forum: Sphider Help
Topic: Updating Error
Replies: 37
Views: 752

Re: Updating Error

Just looking ahead in the event second part of the snippet (the query) fails to produce "Success".... Just on a hunch, try this snippit: <?php $database="sphider"; $mysql_user = "root"; $mysql_password = ""; $mysql_host = "localhost"; $mysql_table_prefix = ""; $dsn = "mysql:host=".$mysql_host.";dbna...
by captquirk
Tue Dec 11, 2018 8:10 pm
Forum: Sphider Help
Topic: Updating Error
Replies: 37
Views: 752

Re: Updating Error

Well, that settles part of it. Try the second half of the snippet to see if it is successfully executing a query.
by captquirk
Tue Dec 11, 2018 6:38 pm
Forum: Sphider Help
Topic: Updating Error
Replies: 37
Views: 752

Re: Updating Error

Here is a test script based on database.php. If the database, user, or password is wrong, you get a warning and message "Database connection failed" and an error number. If the host is wrong, you get nothing. If the table prefix is wrong, you get a "Failed to execute statement" message. If the state...
by captquirk
Tue Dec 11, 2018 4:20 pm
Forum: Sphider Help
Topic: Updating Error
Replies: 37
Views: 752

Re: Updating Error

I take it you are getting the very top of the admin page, then ..... nothing. I had the same thing happen to me when setting up for some testing on another machine. Admin first asks for 'auth.php'. That gets things started. Auth includes 'database.php', which opens the database. Admin sets a couple ...
by captquirk
Tue Dec 11, 2018 7:28 am
Forum: Sphider Help
Topic: Updating Error
Replies: 37
Views: 752

Re: Updating Error

Looking ahead to after you have Sphider 2.2 running.... You mentioned using different directories because you need a couple different languages on your site. With 1.3.5, this works fine because all configuration settings are stored in a file. With Sphider 2.2, they are stored in the database. So the...
by captquirk
Tue Dec 11, 2018 6:01 am
Forum: Sphider Help
Topic: Updating Error
Replies: 37
Views: 752

Re: Updating Error

The error message most likely is not critical and easy to correct--- ONCE YOU GET INTO ADMIN.PHP! One value in the settings table (for a tabbed search) most likely did not get populated. You can check that value and do a save. Then if you don't want a tabbed search, uncheck it and do another save. I...