rendered paste bodymysql> alter table vars add preload tinyint;
Query OK, 272 rows affected (0.02 sec)
Records: 272 Duplicates: 0 Warnings: 0
mysql> desc vars;
+-------------+--------------------------------------------------------------+------+-----+-------------------+-----------------------------+
| Field | Type | Null | Key | Default | Extra |
+-------------+--------------------------------------------------------------+------+-----+-------------------+-----------------------------+
| id | bigint(20) unsigned | NO | PRI | NULL | auto_increment |
| name | varchar(100) | NO | MUL | NULL | |
| site_id | int(10) unsigned | NO | MUL | 0 | |
| title | varchar(255) | NO | | NULL | |
| value | text | NO | | NULL | |
| description | text | NO | | NULL | |
| type | set('','web','toolkit','mut','order','shipping','all','acl') | YES | MUL | NULL | |
| updated | timestamp | NO | | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP |
| meta | varchar(100) | NO | | hidden | |
| params | blob | YES | | NULL | |
| preload | tinyint(4) | YES | | NULL | |
+-------------+--------------------------------------------------------------+------+-----+-------------------+-----------------------------+
11 rows in set (0.01 sec)
mysql> quit
Bye
[root@admod /home/divinity/heavymetal/tmp]# cd ..
[root@admod /home/divinity/heavymetal]# ls tmp/
categories_filedrop fulfillment pdf revert smarty_cache
ftp logfile products_filedrop rudolf.reflection.divinity.php smarty_compiled
[root@admod /home/divinity/heavymetal]# cd tmp/
[root@admod /home/divinity/heavymetal/tmp]# rm *.php
[root@admod /home/divinity/heavymetal/tmp]# cd ..
[root@admod /home/divinity/heavymetal]# cd snippets/
[root@admod /home/divinity/heavymetal/snippets]# php mut.php
NOTICE: Undefined index: time_zone at /usr/home/divinity/heavymetal/lib/masdb/vars.php(120)
NOTICE: date_default_timezone_set(): Timezone ID '' is invalid at /usr/home/divinity/heavymetal/lib/masdb/vars.php(121)
NOTICE: Undefined index: time_zone at /usr/home/divinity/heavymetal/lib/masdb/vars.php(124)
EMERGENCY: Exception (SQLException) - Could not execute update [Native Error: Unknown or incorrect time zone: ''] [User Info: SET time_zone = '', sql_auto_is_null = 0, wait_timeout = 30]
-------------------------------------------------------------------------------
Source File: /usr/home/divinity/heavymetal/lib/3rdparty/creole/drivers/mysqli/MySQLiConnection.php (line: 243)
00236: {
00237: self::$sql[] = $sql;
00238: $this->lastQuery =& self::$sql[count(self::$sql)-1]; /* reference to the last executed sql */
00239: //$this->lastQuery = $sql;
00240:
00241: $result = @mysqli_query($this->dblink, $sql);
00242: if (!$result) {
>00243: throw new SQLException('Could not execute update',
00244: is_object($this->dblink)
00245: ? mysqli_error($this->dblink)
00246: : mysqli_connect_error()
00247: , $sql);
00248: }
00249: return (int) mysqli_affected_rows($this->dblink);
00250: }
00251:
-------------------------------------------------------------------------------
Stack Trace:
#0 /usr/home/divinity/heavymetal/lib/database.php(469): MySQLiConnection->executeUpdate('SET time_zone =...')
#1 /usr/home/divinity/heavymetal/lib/masdb/vars.php(129): database::flush_set()
#2 /usr/home/divinity/heavymetal/lib/masdb/vars.php(624): vars::preload_vars()
#3 /usr/home/divinity/heavymetal/lib/functions.php(167): include_once('/usr/home/divin...')
#4 [internal function]: __autoload('vars')
#5 /usr/home/divinity/heavymetal/lib/rudolf/metadata.php(207): ReflectionClass->__construct('vars')
#6 /usr/home/divinity/heavymetal/lib/rudolf/record.php(682): rudolf_metadata::extract_reflection_data('vars')
#7 /usr/home/divinity/heavymetal/lib/rudolf/record.php(453): rudolf_record::scan_columns(true, 'rudolf_record::...')
#8 /usr/home/divinity/heavymetal/snippets/common.php(19): rudolf_record::init_db()
#9 /usr/home/divinity/heavymetal/snippets/mut.php(4): require_once('/usr/home/divin...')
#10 {main}
-------------------------------------------------------------------------------
2011-05-27 19:45:02 +0000: core(17436)
Emergency: file:1306525502/no_log