[siosios]

IE 7

[FredJed223]

Originally Posted by Olly Ok, for those of you who were having troubles with the updater. Or are having Undefined index notices... Please re-download the package (http://www.sourcebans.net/filebrowser), and copy over: /init.php /updater/data/112.php Then either re-run the updater again, or continue using

Ok seems to be working now.

What about a fix for servers with squares in the name?

[marrr]

i just redownloaded and tried again...

Incorrect datetime value: '1219609732' for column 'lastvisit' at row 1 SQL Query type: EXECUTE Script: '/sourcebans/updater/index.php' SQL Query: UPDATE `sb_admins` SET `lastvisit` = UNIX_TIMESTAMP() WHERE `aid` = '1' SQL Params: $('msg-red-debug').setStyle('display', 'block');$('115f895').getChildren().injectIns ide('debug-text');$('115f895').getChildren().remove();Data truncated for column 'lastvisit' at row 1 SQL Query type: EXECUTE Script: '/sourcebans/updater/index.php' SQL Query: ALTER TABLE `sb_admins` CHANGE `lastvisit` `lastvisit` INT( 11 ) NULL DEFAULT NULL SQL Params: $('msg-red-debug').setStyle('display', 'block');$('e0cf1f4').getChildren().injectIns ide('debug-text');$('e0cf1f4').getChildren().remove(); Debug Updater Setup... Checking current database version... 1 Updating database to version: 112 Updating... Running update: v112... Error executing: /updater/data/112.php. Stopping Update! Update Failed.

[Olly]

Originally Posted by marrr i just redownloaded and tried again...

Please confirm that your /updater/data/112.php file contains this line

$GLOBALS['db']->Execute("UPDATE ".DB_PREFIX."_admins SET lastvisit = '0000-00-00 00:00:00' WHERE aid = " . $adm['aid']);

[marrr]

yes

} $admins = $GLOBALS['db']->GetAll("SELECT * FROM ".DB_PREFIX."_admins"); foreach ($admins as $adm) { $GLOBALS['db']->Execute("UPDATE ".DB_PREFIX."_admins SET lastvisit = '0000-00-00 00:00:00' WHERE aid = " . $adm['aid']); }

[Olly]

If you have access to phpMyAdmin or something, can you browse sb_log, and find the newest entry that contains 'sql error' as the title, and has 1219609732 somewhere in the message.

SELECT *
FROM `sb_log`
WHERE `title` LIKE '%sql%'
AND `message` LIKE '%1219609732%'
ORDER BY lid DESC

run that, and paste the contents of the 'message' field please.

[marrr]

nah i dont have access to phpMyAdmin its hosted by my gsp.

[Olly]

Originally Posted by marrr nah i dont have access to phpMyAdmin its hosted by my gsp.

Ok, create a new file in the root of the sourcebans folder, and call it 'log.php'

and add this to it:

<?php
 define('IS_UPDATE', true);
 include "../init.php";
 $gaben = $GLOBALS['db']->Execute("SELECT ".DB_PREFIX."_log WHERE `title` LIKE '%sql%' AND `message` LIKE '%1219609732%' ORDER BY lid DESC LIMIT 0,1");
 echo $gaben->fields['message']; 
?>

Now navigate to this file though your browser, and paste what it says

[marrr]

wont even let me load the log.php 500 internal server error.. I checked out the error log and it says

[24-Aug-2008 16:26:59] PHP Warning: include(../init.php) [<a href='function.include'>function.include</a>]: failed to open stream: No such file or directory in /home/marrr/public_html/sourcebans/log.php on line 3 [24-Aug-2008 16:26:59] PHP Warning: include(../init.php) [<a href='function.include'>function.include</a>]: failed to open stream: No such file or directory in /home/marrr/public_html/sourcebans/log.php on line 3 [24-Aug-2008 16:26:59] PHP Warning: include() [<a href='function.include'>function.include</a>]: Failed opening '../init.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/marrr/public_html/sourcebans/log.php on line 3 [24-Aug-2008 16:26:59] PHP Fatal error: Call to a member function Execute() on a non-object in /home/marrr/public_html/sourcebans/log.php on line 4 [24-Aug-2008 16:27:15] PHP Warning: include(../init.php) [<a href='function.include'>function.include</a>]: failed to open stream: No such file or directory in /home/marrr/public_html/sourcebans/log.php on line 3 [24-Aug-2008 16:27:15] PHP Warning: include(../init.php) [<a href='function.include'>function.include</a>]: failed to open stream: No such file or directory in /home/marrr/public_html/sourcebans/log.php on line 3 [24-Aug-2008 16:27:15] PHP Warning: include() [<a href='function.include'>function.include</a>]: Failed opening '../init.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/marrr/public_html/sourcebans/log.php on line 3 [24-Aug-2008 16:27:15] PHP Fatal error: Call to a member function Execute() on a non-object in /home/marrr/public_html/sourcebans/log.php on line 4

[Olly]

Originally Posted by marrr wont even let me load the log.php 500 internal server error.. I checked out the error log and it says

oops, wow its not my day ><

Replace the contents of log.php with this:

<?php
 define('IS_UPDATE', true);
 include "init.php";
 $gaben = $GLOBALS['db']->Execute("SELECT ".DB_PREFIX."_log WHERE `title` LIKE '%sql%' AND `message` LIKE '%1219609732%' ORDER BY lid DESC LIMIT 0,1");
 echo $gaben->fields['message']; 
?>