Ca$h MOD

[Jdude]

I did what I did in your last post and it said next step! I was like woohoo! I went ahead and clicked it and now I have:

Code: Select all

SQL PROCESSING ERROR:
No SQL alterations will be performed. However, you may skip SQL processing, continue installing the MOD, and deal with the SQL manually

The following error occured:

Error:
Unknown SQL command ";", statement: 1

SQL:

[Jdude]

It said I could skip it. I did and now I have another error, time to restore my backups....

[Jdude]

NO! NO NO NO! The admin panel is ruined. I can't get to anything!

Trying to view a topic I get: message_die() was called multiple times. This isn't supposed to happen. Was message_die() used in page_tail.php?

And in ACP: Error retrieving cash data

DEBUG MODE

SQL Error : 1146 Table 'cooljdud_phpb1.phpbb_cash' doesn't exist

SELECT * FROM phpbb_cash ORDER BY cash_order ASC

Line : 657
File : functions_cash.php

[Nightrider]

Thanks for cleaning that up...

No, your ACP is not ruined. Do the manual Restore Backups option again like I mentioned and worked so well for you...

Then I will need to know the error message you are getting. If it's only the SQL error, then follow these instructions provide by the MOD author to update your database...

#
#-----[ SQL ]------------------------------------------
#
# There is an automatic sql installer that works currently for mysql and mssql
# It is neccessary to copy the file sql_install.php to your main phpbb directory and run it from there
# After that, you want to delete the file immediately.
#
# If you prefer to run the queries manually yourself, or to translate it to a different dbms
# than mysql or mssql, the raw queries are located in sql_221.txt, but are only available for mysql.
# I will try to include more dbms's for the installer for future releases, but nothing is guaranteed
# at present
#

[Nightrider]

Actually if that is the only error you have, you don't have to restore any backups. Once you update your database with the included DB Update file, then all should work normally again...

In the future, it might be a good idea to read the Author's Notes before installing a MOD. You might see what to do before there is a problem...

Also, you might consider creating a Test board so that your Live community is never adversely affected if a MOD hoses your board. That would allow you more time to take care of the problem with a lot less stress...

Creating Test phpBB Board

I can give you enough to get started.

1. The first thing you want to do is download all of your board files and folders to your PC.
2. Next, create a folder on your server called Test...
3. Upload all of the board files and folders that you just downloaded to your PC back to your new Test folder...
4. Create a new Test database
5. Open the Test config.php file in your favorite editor and modify the dbname, dbuser, and dbpasswd settings to match your new Test Database
6. Create a database backup of your Live board database from your ACP...
7. Restore your new database backup back to your new Test database. This will probably take a long time. You will probably need some help with this step unless you are very familiar with phpMyAdmin...
8. Modify phpbb_config table settings in your Test database that contain a full or partial board path to match the URL path on your new board

Your new Test board should be good to go at this point. My instructions above may take some time to accomplish, but it is worth it to have a Test board available to test install new MODs that you want to install on your Live board.

[Jdude]

Well, that worked, I think the Ca$h MOD is a success for me finally. I'm always going to read the author's notes from now on...

[Jdude]

Well, I'm pretty much done with this as the MOD is installed, I'm gonna lock this...