PhotoPost Photo Gallery Sales PhotoPost Sales Toll Free Phone Number
Mon-Fri 9am-4pm EST
  PhotoPost Photo Sharing Photo Gallery    Visualize community tm
| | | | | | | | |

Go Back   PhotoPost Community > PhotoPost Support > PhotoPost Classifieds Support > Classifieds Installation & Upgrades

Classifieds Installation & Upgrades If you're having install or upgrade problems, post here.

Reply
 
LinkBack Thread Tools Rate Thread Display Modes
Old June 20th, 2005, 09:56 AM   #1 (permalink)
Ultimate Member
Verified Customer
 
Join Date: Sep 2002
Posts: 1,217
error with first backup after fresh install

Hi,

I just installed Classifieds (fresh install). I now try to make a backup. This error occurs:

-----------

Results:


Warning: filesize(): Stat failed for /ppclassde_admingroups.sql (errno=2 - No such file or directory) in /my path to/classified/adm-backup.php on line 76
Warning: ppclassde_admingroups.sql is 0 bytes or did not get created.
Warning: filesize(): Stat failed for /ppclassde_admlog.sql (errno=2 - No such file or directory) in /my path to/classified/adm-backup.php on line 76
Warning: ppclassde_admlog.sql is 0 bytes or did not get created.
Warning: filesize(): Stat failed for /ppclassde_adtypes.sql (errno=2 - No such file or directory) in /my path to/classified/adm-backup.php on line 76
Warning: ppclassde_adtypes.sql is 0 bytes or did not get created.
Warning: filesize(): Stat failed for /ppclassde_bidding.sql (errno=2 - No such file or directory) in /my path to/classified/adm-backup.php on line 76
Warning: ppclassde_bidding.sql is 0 bytes or did not get created.
Warning: filesize(): Stat failed for /ppclassde_bids.sql (errno=2 - No such file or directory) in /my path to/classified/adm-backup.php on line 76
Warning: ppclassde_bids.sql is 0 bytes or did not get created.
Warning: filesize(): Stat failed for /ppclassde_categories.sql (errno=2 - No such file or directory) in /my path to/classified/adm-backup.php on line 76
Warning: ppclassde_categories.sql is 0 bytes or did not get created.
Warning: filesize(): Stat failed for /ppclassde_comments.sql (errno=2 - No such file or directory) in /my path to/classified/adm-backup.php on line 76
Warning: ppclassde_comments.sql is 0 bytes or did not get created.
Warning: filesize(): Stat failed for /ppclassde_favorites.sql (errno=2 - No such file or directory) in /my path to/classified/adm-backup.php on line 76
Warning: ppclassde_favorites.sql is 0 bytes or did not get created.
Warning: filesize(): Stat failed for /ppclassde_feedback.sql (errno=2 - No such file or directory) in /my path to/classified/adm-backup.php on line 76
Warning: ppclassde_feedback.sql is 0 bytes or did not get created.
Warning: filesize(): Stat failed for /ppclassde_ipcache.sql (errno=2 - No such file or directory) in /my path to/classified/adm-backup.php on line 76
Warning: ppclassde_ipcache.sql is 0 bytes or did not get created.
Warning: filesize(): Stat failed for /ppclassde_iponline.sql (errno=2 - No such file or directory) in /my path to/classified/adm-backup.php on line 76
Warning: ppclassde_iponline.sql is 0 bytes or did not get created.
Warning: filesize(): Stat failed for /ppclassde_laston.sql (errno=2 - No such file or directory) in /my path to/classified/adm-backup.php on line 76
Warning: ppclassde_laston.sql is 0 bytes or did not get created.
Warning: filesize(): Stat failed for /ppclassde_notify.sql (errno=2 - No such file or directory) in /my path to/classified/adm-backup.php on line 76
Warning: ppclassde_notify.sql is 0 bytes or did not get created.
Warning: filesize(): Stat failed for /ppclassde_payments.sql (errno=2 - No such file or directory) in /my path to/classified/adm-backup.php on line 76
Warning: ppclassde_payments.sql is 0 bytes or did not get created.
Warning: filesize(): Stat failed for /ppclassde_products.sql (errno=2 - No such file or directory) in /my path to/classified/adm-backup.php on line 76
Warning: ppclassde_products.sql is 0 bytes or did not get created.
Warning: filesize(): Stat failed for /ppclassde_settings.sql (errno=2 - No such file or directory) in /my path to/classified/adm-backup.php on line 76
Warning: ppclassde_settings.sql is 0 bytes or did not get created.
Warning: filesize(): Stat failed for /ppclassde_sort.sql (errno=2 - No such file or directory) in /my path to/classified/adm-backup.php on line 76
Warning: ppclassde_sort.sql is 0 bytes or did not get created.
Warning: filesize(): Stat failed for /ppclassde_stats.sql (errno=2 - No such file or directory) in /my path to/classified/adm-backup.php on line 76
Warning: ppclassde_stats.sql is 0 bytes or did not get created.
Warning: filesize(): Stat failed for /ppclassde_usergroups.sql (errno=2 - No such file or directory) in /my path to/classified/adm-backup.php on line 76
Warning: ppclassde_usergroups.sql is 0 bytes or did not get created.
Warning: filesize(): Stat failed for /ppclassde_users.sql (errno=2 - No such file or directory) in /my path to/classified/adm-backup.php on line 76
Warning: ppclassde_users.sql is 0 bytes or did not get created.
Warning: filesize(): Stat failed for /zipData.sql (errno=2 - No such file or directory) in /my path to/classified/adm-backup.php on line 76
Warning: zipData.sql is 0 bytes or did not get created.

------------

What can be the reason for this?

Thanks in advance
snoopy5 is offline   Reply With Quote
Old June 20th, 2005, 10:00 AM   #2 (permalink)
Photopost Developer
Verified Customer
 
Chuck S's Avatar
 
Join Date: Jun 2002
Location: Abingdon,MD
Posts: 71,702
Have you set the backup directory full path and chmod to 777?

Have you set the path to mysqldump on the server?

Note is mysql is on an external server you can not use the backup utility since we need mysqldump access
__________________
Photopost Developer and Support Engineer

Please do not PM me for support or sales questions. Thank you for your understanding.
Chuck S is online now   Reply With Quote
Old June 20th, 2005, 10:20 AM   #3 (permalink)
Ultimate Member
Verified Customer
 
Join Date: Sep 2002
Posts: 1,217
Quote:
Originally Posted by omegatron
Have you set the backup directory full path and chmod to 777?
Yes

Quote:
Originally Posted by omegatron
Have you set the path to mysqldump on the server?
Yes

Quote:
Originally Posted by omegatron
Note is mysql is on an external server you can not use the backup utility since we need mysqldump access
Do not know for sure, but since all my Photopost and reviewpost installations are working properly on that server, I assume everything is fine.
snoopy5 is offline   Reply With Quote
Old June 20th, 2005, 10:36 AM   #4 (permalink)
Photopost Developer
Verified Customer
 
Chuck S's Avatar
 
Join Date: Jun 2002
Location: Abingdon,MD
Posts: 71,702
Try making the contents of your adm-backup.php file this

Code:
Content visible to verified customers only.
__________________
Photopost Developer and Support Engineer

Please do not PM me for support or sales questions. Thank you for your understanding.
Chuck S is online now   Reply With Quote
Old June 20th, 2005, 10:59 AM   #5 (permalink)
Ultimate Member
Verified Customer
 
Join Date: Sep 2002
Posts: 1,217
nope, this gives me this result:

------

?php //////////////////////////// COPYRIGHT NOTICE /////////////////////////////////// // This script is part of PhotoPost Classifieds PHP, a software application by // // All Enthusiast, Inc. Use of any kind of part or all of this // // script or modification of this script requires a license from All // // Enthusiast, Inc. Use or modification of this script without a license // // constitutes Software Piracy and will result in legal action from All // // Enthusiast, Inc. All rights reserved. // // http://www.photopost.com legal@photopost.com // // Contributing Developer: Michael Pierce (mpdev.net) // // // // PhotoPost Classifieds Copyright 2005, All Enthusiast, Inc. // ///////////////////////////////////////////////////////////////////////////////// require "adm-inc.php"; if ( $User['adminedit'] != 1 ) { diewell( "You are not a valid administrator!" ); exit; } //# Generate the edit categories HTML form adminheader( 0, "PhotoPost Classifieds Database Backup Admin" ); print "

PhotoPost Classifieds Database Backup
"; if ( !isset($table) ) { print ""; $tables = mysql_list_tables($database); while (list($table) = mysql_fetch_array($tables)) { print ""; print ""; } print "
"; print "You can backup tables individually or all of them at one. You should set your gallery to CLOSED in your config-inc.php file while doing a backup.

Note: Backup uses the mysqldump command, so make sure that the path to this command is set properly below (this is set in the config file). Large databases may timeout if you do them all at once and you may need to backup tables individually. MySQL 4.x requires that the database user that your gallery is using has LOCK TABLES permissions.

"; print "Path to mysqldump: {$Globals['mysqldumppath']}
"; print "Directory to store backups: {$Globals['backupdir']}

"; print "
$table Backup

Backup ALL tables
"; } else { print "
"; if ( $table != "all" ) { $tables[0] = $table; } else { $i=0; $dbtables = mysql_list_tables($database); while(list($table) = mysql_fetch_array($dbtables)) { $tables[$i] = $table; $i++; } } $dumpcmd = "{$Globals['mysqldumppath']} --opt -h $host -u$mysql_user -p$mysql_password $database "; print "Command being used to execute dumps (specific tables are executed individually):

$dumpcmd

"; print "Results:

"; foreach($tables as $tablename) { $tablename = escapeshellcmd($tablename); $thedumpcmd = $dumpcmd . "$tablename > {$Globals['backupdir']}/$tablename.sql"; system($thedumpcmd); $size = filesize("{$Globals['backupdir']}/$tablename.sql"); if (!$size) { print "Warning: $tablename.sql is 0 bytes or did not get created."; } else { print "$tablename has been backed up.
"; } } adminlog( "Performed a database backup" ); print "

You should double-check your .sql files to be sure the backup completed successfully."; } print "

"; adminfooter(); ?>

-----------------
snoopy5 is offline   Reply With Quote
Old June 20th, 2005, 11:15 AM   #6 (permalink)
Photopost Developer
Verified Customer
 
Chuck S's Avatar
 
Join Date: Jun 2002
Location: Abingdon,MD
Posts: 71,702
You have not copied the file right then. Your missing the opening < tag it looks like
__________________
Photopost Developer and Support Engineer

Please do not PM me for support or sales questions. Thank you for your understanding.
Chuck S is online now   Reply With Quote
Old June 20th, 2005, 11:49 AM   #7 (permalink)
Ultimate Member
Verified Customer
 
Join Date: Sep 2002
Posts: 1,217
ah. ok.

I added the opening tag and now it works.

Thanks
snoopy5 is offline   Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Fresh install error..?? Really Stuck..!! doogle Installs and Upgrade - vBulletin 3.5.X 1 October 12th, 2005 01:14 PM
Fresh install error after first log-in bill03 Classifieds Installation & Upgrades 1 September 1st, 2005 06:57 AM
Classiefieds 2.3 fresh install - error 500 snoopy5 Classifieds Installation & Upgrades 20 June 20th, 2005 12:40 PM
error during fresh install alf2g Photopost Pro Installation & Upgrades 1 July 19th, 2004 07:44 AM
Fresh Install 4.8d + Threads .6x and MySQL Error Keet Photopost Pro Installation & Upgrades 4 July 18th, 2004 07:44 PM


All times are GMT -5. The time now is 09:13 AM.

Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0