Welcome to RCF - WHF

Cowboy69 · Apr 01, 2007

Here ya go

KeeKee · Mar 20, 2006

I tried to install the zero users on the test board and it kept giving me the usual cannot make directory so kept restarting it finally it said there was a syntax error in the SQL then it said successful but I logged in with one of my personas and the 0's were still there so it's not working.

Cowboy69 · Apr 01, 2007

The zero users or the prune users ?

Nightrider · Sep 25, 2004

The problem was that EM was not able to run all of the SQL queries. So I have created a DB Update file that you can run to update your database. After running this on your Test board, everything is working as advertised...

zero_uerss_db_update.zip

headbang

KeeKee · Mar 20, 2006

I installed to hobbies and ran the update and this is what it says.

"config.php not found. make sure you have uploaded file to your forum directory."

Cowboy69 · Apr 01, 2007

Did you make sure its there ? if so it sounds like chmod setting needs to be changed so you can access it

Nightrider · Sep 25, 2004

Did you upload the zero_uerss_db_update.php file to your hobbies folder and run it from your browser? The path would look something like this:

http://care-away.com/forums/hobbies/zero_uerss_db_update.php

headbang

KeeKee · Mar 20, 2006

oh I uploaded it deeper than that uploaded it with the mod not in the main folder Embarassed

KeeKee · Mar 20, 2006

Oh great I guess I got this because I didn't take out the check marks after getting the SQL error and before hitting the complete installation.

error in query 1: Duplicate column name 'user_firstpost'
error in query 4: Duplicate entry 'zero_count' for key 1
done (4 queries).

So now I guess I need to go to the database and take out the duplicates.

Instructions please?

Nightrider · Sep 25, 2004

No, you don't need to do a thing. SQL cannot create duplicate tables, fields (columns), or keyed records. So if you attempt to create duplicates in your database, you would expect to see these errors. No harm was done by trying though...

headbang