WHAT THE crappity smack

[P2D]

The site works half fine, He using the SSI but now half of it works, they hacked the forum only... what a child.... he dosent have a life, I use yabb se 1.31 (Safe-mode) with attachments was on.

[Greg Robson]

I suggest you get in the habit of backing up - until Dave Smulders finishes his backup manager you can use the backup script I have made:

http://www.yabb.info/community/index.php?board=1;action=display;threadid=7224

[P2D]

Thank you very much

[P2D]

When i try to make a backup, i get this errors.

Written by Greg Robson

Connecting to the database...DONE
Opening backup file...DONE
Backing up table 'banned'...
Warning: Supplied argument is not a valid MySQL result resource in /home/virtual/site10/fst/var/www/html/yabbse_backup/backup.php on line 60

Warning: Supplied argument is not a valid MySQL result resource in /home/virtual/site10/fst/var/www/html/yabbse_backup/backup.php on line 62

[Greg Robson]

Well if you're settings are pointing to the correct database I can only assume that it's having trouble finding the banned table?
* Greg is puzzled
Double check the settings...
[edit]
Check the prefix - the default I use is nothing - the installer uses yabbse_
that might be it - you can always check from the forum preferences and settings page in the admin section.
[/edit]

[P2D]

i get this to all the tables... The table prefix is yabbse_ the host is localhost and the username and password is ......... cant tell you lol

Written by Greg Robson

Connecting to the database...DONE
Opening backup file...DONE
Backing up table 'banned'...
Warning: Supplied argument is not a valid MySQL result resource in /home/virtual/site10/fst/var/www/html/yabbse_backup/backup.php on line 60

Warning: Supplied argument is not a valid MySQL result resource in /home/virtual/site10/fst/var/www/html/yabbse_backup/backup.php on line 62
DONE
Backing up table 'boards'...
Warning: Supplied argument is not a valid MySQL result resource in /home/virtual/site10/fst/var/www/html/yabbse_backup/backup.php on line 60

Warning: Supplied argument is not a valid MySQL result resource in /home/virtual/site10/fst/var/www/html/yabbse_backup/backup.php on line 62
DONE
Backing up table 'categories'...
Warning: Supplied argument is not a valid MySQL result resource in /home/virtual/site10/fst/var/www/html/yabbse_backup/backup.php on line 60

Warning: Supplied argument is not a valid MySQL result resource in /home/virtual/site10/fst/var/www/html/yabbse_backup/backup.php on line 62
DONE
Backing up table 'censor'...
Warning: Supplied argument is not a valid MySQL result resource in /home/virtual/site10/fst/var/www/html/yabbse_backup/backup.php on line 60

blablabla

[P2D]

The settings are correct.

[Greg Robson]

If the database name is correct then I don't know what it could be?
Help!?!

[P2D]

yup the database name is correct

$settings['db_name'] = '24kteam_saburovo_com';
$settings['db_user'] = 'stealer';
$settings['db_password'] = '(Hidden)';
$settings['db_host'] = 'localhost';
$settings['tb_prefix'] = 'yabbse_';
$settings['recreate_structure'] = 1;
$settings['backup_file'] = 'backup.sql';
$settings['settings_path'] = '/home/virtual/site10/fst/var/www/html/yabbse/Settings.php';

[Greg Robson]

Aha!

Got it!

Look in subs.php for this...

Code Select Expand

function add_prefix(&$tables)
{
   if ($settings['tb_prefix'] != '')
   {
      for ($i = 0; $i < count($tables); $i++)
         $tables[$i] = $settings['tb_prefix'] . $tables[$i];
   }
I didn't globalise $settings['tb_prefix'] so the prefix isn't added! (Or rather it is - but it's an empty string)
It should read

Code Select Expand

function add_prefix(&$tables)
{
   global $settings['tb_prefix'];

   if ($settings['tb_prefix'] != '')
   {
      for ($i = 0; $i < count($tables); $i++)
         $tables[$i] = $settings['tb_prefix'] . $tables[$i];
   }
}

That should fix it

[P2D]

Parse error: parse error, expecting `','' or `';'' in /home/virtual/site10/fst/var/www/html/yabbse_backup/subs.php on line 48

YaBB SE Backup System
Written by Greg Robson

Connecting to the database...DONE
Opening backup file...DONE

Fatal error: Call to undefined function: add_prefix() in /home/virtual/site10/fst/var/www/html/yabbse_backup/backup.php on line 50

 

[P2D]

Line 48:   global $settings['tb_prefix'];

[Greg Robson]

Yep - that's it.
* Greg makes a note to himself to fix it in the downloadable release

btw: thanks for being a beta tester

[P2D]

I dont think it is possible to global array in that way...

[P2D]

YAY i changed the line to
global $settings;

and it worked fine.


Written by Greg Robson

Connecting to the database...DONE
Opening backup file...DONE
Backing up table 'yabbse_banned'...DONE
Backing up table 'yabbse_boards'...DONE
Backing up table 'yabbse_categories'...DONE
Backing up table 'yabbse_censor'...DONE
Backing up table 'yabbse_instant_messages'...DONE
Backing up table 'yabbse_log_activity'...DONE
Backing up table 'yabbse_log_banned'...DONE
Backing up table 'yabbse_log_boards'...DONE
Backing up table 'yabbse_log_clicks'...DONE
Backing up table 'yabbse_log_errors '...DONE
Backing up table 'yabbse_log_floodcontrol'...DONE
Backing up table 'yabbse_log_karma'...DONE
Backing up table 'yabbse_log_mark_read'...DONE
Backing up table 'yabbse_log_online'...DONE
Backing up table 'yabbse_log_topics'...DONE
Backing up table 'yabbse_membergroups'...DONE
Backing up table 'yabbse_members'...DONE
Backing up table 'yabbse_messages'...DONE
Backing up table 'yabbse_polls'...DONE
Backing up table 'yabbse_reserved_names'...DONE
Backing up table 'yabbse_settings'...DONE
Backing up table 'yabbse_topics'...DONE
Closing file...DONE
Closing database connection...DONE