 | |  | | | ReviewPost Bug Reports Let us know about any post installation problems you are having with ReviewPost. |
March 21st, 2005, 04:16 AM
|
#1 (permalink)
| | Senior Member Verified Customer
Join Date: Jun 2003 Location: London, UK
Posts: 567
| Upgraded to v2.9 now backup not working
Just upgraded to version 2.9 and when using the backup function reveive the following errors:
Warning: rp_admingroups.sql is 0 bytes or did not get created.Warning: rp_admlog.sql is 0 bytes or did not get created.Warning: rp_categories.sql is 0 bytes or did not get created.Warning: rp_favorites.sql is 0 bytes or did not get created.Warning: rp_ipcache.sql is 0 bytes or did not get created.Warning: rp_iponline.sql is 0 bytes or did not get created.Warning: rp_laston.sql is 0 bytes or did not get created.Warning: rp_notify.sql is 0 bytes or did not get created.Warning: rp_products.sql is 0 bytes or did not get created.Warning: rp_reviews.sql is 0 bytes or did not get created.Warning: rp_settings.sql is 0 bytes or did not get created.Warning: rp_sort.sql is 0 bytes or did not get created.Warning: rp_usergroups.sql is 0 bytes or did not get created.Warning: rp_users.sql is 0 bytes or did not get created.
Backup was working fine before I did the upgrade.
|
| |
March 27th, 2005, 12:13 PM
|
#2 (permalink)
| | Senior Member Verified Customer
Join Date: Jun 2003 Location: London, UK
Posts: 567
|
Any answer to my question?
|
| |
March 27th, 2005, 08:00 PM
|
#3 (permalink)
| | Photopost Developer Verified Customer
Join Date: Jun 2002 Location: Abingdon,MD
Posts: 68,070
|
try this file Code: Content visible to verified customers only.
Last edited by Chuck S; March 28th, 2005 at 05:20 PM.
|
| |
March 28th, 2005, 04:48 PM
|
#4 (permalink)
| | Senior Member Verified Customer
Join Date: Jun 2003 Location: London, UK
Posts: 567
|
I created a file called adm-backup.php using the code...
Running the PHP file reference is made to 'PhotoPost Classifieds Database Backup' and after clicking on 'backup all tables' the following is output:
Results:
Warning: rp_admingroups.sql is 0 bytes or did not get created.Warning: rp_admlog.sql is 0 bytes or did not get created.Warning: rp_categories.sql is 0 bytes or did not get created.Warning: rp_favorites.sql is 0 bytes or did not get created.Warning: rp_ipcache.sql is 0 bytes or did not get created.Warning: rp_iponline.sql is 0 bytes or did not get created.Warning: rp_laston.sql is 0 bytes or did not get created.Warning: rp_notify.sql is 0 bytes or did not get created.Warning: rp_products.sql is 0 bytes or did not get created.Warning: rp_reviews.sql is 0 bytes or did not get created.Warning: rp_settings.sql is 0 bytes or did not get created.Warning: rp_sort.sql is 0 bytes or did not get created.Warning: rp_usergroups.sql is 0 bytes or did not get created.Warning: rp_users.sql is 0 bytes or did not get created.
We're sorry, but the system experienced an unrecoverable error. Please try again later.
Script: adm-backup
Query: REPLACE INTO admlog (adminuser,ip,datestamp,description) VALUES ('Bart','195.157.204.229','1112050027','Performed a database backup')
Result: Table 'scene-outreviews.admlog' doesn't exist
Database handle: Resource id #6
|
| |
March 28th, 2005, 05:21 PM
|
#5 (permalink)
| | Photopost Developer Verified Customer
Join Date: Jun 2002 Location: Abingdon,MD
Posts: 68,070
|
Try the file above I corrected the admin login prefix thing
Is it getting your variables for directory and mysqldump path?
post your error here
|
| |
March 28th, 2005, 05:43 PM
|
#6 (permalink)
| | Senior Member Verified Customer
Join Date: Jun 2003 Location: London, UK
Posts: 567
|
It's not getting the variables for directory and mysqldump path even though they're set correctly (checked in /adm-editcfg.php).
|
| |
March 30th, 2005, 12:35 PM
|
#7 (permalink)
| | Senior Member Verified Customer
Join Date: Jun 2003 Location: London, UK
Posts: 567
|
Anyone able to offer any assistance?
|
| |
March 30th, 2005, 01:14 PM
|
#8 (permalink)
| | Photopost Developer Verified Customer
Join Date: Jun 2002 Location: Abingdon,MD
Posts: 68,070
|
Do you have an older Reviewpost laying around?
Problem is I dont see why it would not be picking up these variables.
We include adm-inc.php which includes pp-inc.php which requires config-inc.php
I do have one suggestion and that is to edit your config file and copy and paste those variables into your adm-backup.php file until I can do more testing.
That will surely fix it in the time being.
|
| |
March 30th, 2005, 01:49 PM
|
#9 (permalink)
| | Senior Member Verified Customer
Join Date: Jun 2003 Location: London, UK
Posts: 567
|
I decided to delete my adm-backup.php, created a new one with a fresh copy of the code supplied in this thread. I then ran the script and clicked on backup... and it saw the necessary variables and backed up the tables. Bizarre to say the least :-) !!
Clicking on 'backup your database' in adm-index.php is still broken though.
Last edited by criscokid; March 30th, 2005 at 01:51 PM.
|
| |
March 30th, 2005, 01:52 PM
|
#10 (permalink)
| | Photopost Developer Verified Customer
Join Date: Jun 2002 Location: Abingdon,MD
Posts: 68,070
|
Ah so my file works for you |
| |
March 30th, 2005, 01:56 PM
|
#11 (permalink)
| | Senior Member Verified Customer
Join Date: Jun 2003 Location: London, UK
Posts: 567
|
Thank you very much for your assistance! :-)
|
| | |
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | | | | Thread Tools | | | | Display Modes | Rate This Thread | Linear Mode | |
Posting Rules
| You may not post new threads You may not post replies You may not post attachments You may not edit your posts HTML code is Off | | | All times are GMT -5. The time now is 03:43 PM. | |