Context Navigation

← Previous Ticket
Next Ticket →

Ticket #232 (closed defect: fixed)

Last modified 9 months ago

Problems with Plogger's upgrade script and PHP 5.3

Reported by:	nathanrdotca	Owned by:	sidtheduck
Priority:	normal	Milestone:	1.0
Component:	General	Version:
Severity:	normal	Keywords:
Cc:

Description

(here's a screen paste from the output of _upgrade.php)

Performing Upgrade...

Notice: Use of undefined constant TABLE_PREFIX - assumed 'TABLE_PREFIX' in /var/www/gallery-nathanr-ca/htdocs/_upgrade.php on line 111

Upgrading database structure (TABLE_PREFIXconfig)...

Table TABLE_PREFIXthumbnail_config already exists, ignoring. Notice: Use of undefined constant TABLE_PREFIX - assumed 'TABLE_PREFIX' in /var/www/gallery-nathanr-ca/htdocs/_upgrade.php on line 124

disabled already present in database. Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /var/www/gallery-nathanr-ca/htdocs/_upgrade.php on line 84

Adding new field gallery_url to database. Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /var/www/gallery-nathanr-ca/htdocs/_upgrade.php on line 69
Adding new field feed_num_entries to database. Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /var/www/gallery-nathanr-ca/htdocs/_upgrade.php on line 69
Adding new field feed_title to database. Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /var/www/gallery-nathanr-ca/htdocs/_upgrade.php on line 69
Adding new field feed_language to database. Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /var/www/gallery-nathanr-ca/htdocs/_upgrade.php on line 69
Adding new field use_mod_rewrite to database. Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /var/www/gallery-nathanr-ca/htdocs/_upgrade.php on line 69
Adding new field default_sortdir to database. Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /var/www/gallery-nathanr-ca/htdocs/_upgrade.php on line 69
Adding new field default_sortby to database. Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /var/www/gallery-nathanr-ca/htdocs/_upgrade.php on line 69
Adding new field admin_email to database. Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /var/www/gallery-nathanr-ca/htdocs/_upgrade.php on line 69
Adding new field allow_fullpic to database. Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /var/www/gallery-nathanr-ca/htdocs/_upgrade.php on line 69
Adding new field comments_notify to database. Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /var/www/gallery-nathanr-ca/htdocs/_upgrade.php on line 69
Adding new field comments_moderate to database. Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /var/www/gallery-nathanr-ca/htdocs/_upgrade.php on line 69
Adding new field square_thumbs to database. Notice: Use of undefined constant TABLE_PREFIX - assumed 'TABLE_PREFIX' in /var/www/gallery-nathanr-ca/htdocs/_upgrade.php on line 225

Adding new field thumbnail_id to database. Notice: Use of undefined constant TABLE_PREFIX - assumed 'TABLE_PREFIX' in /var/www/gallery-nathanr-ca/htdocs/_upgrade.php on line 226

Adding new field thumbnail_id to database. Notice: Use of undefined constant TABLE_PREFIX - assumed 'TABLE_PREFIX' in /var/www/gallery-nathanr-ca/htdocs/_upgrade.php on line 229

Adding new field path to database. Notice: Use of undefined constant TABLE_PREFIX - assumed 'TABLE_PREFIX' in /var/www/gallery-nathanr-ca/htdocs/_upgrade.php on line 230

Adding new field path to database. Notice: Use of undefined constant TABLE_PREFIX - assumed 'TABLE_PREFIX' in /var/www/gallery-nathanr-ca/htdocs/_upgrade.php on line 234

Adding new field ip to database. Notice: Use of undefined constant TABLE_PREFIX - assumed 'TABLE_PREFIX' in /var/www/gallery-nathanr-ca/htdocs/_upgrade.php on line 235

Adding new field approved to database. Notice: Use of undefined constant TABLE_PREFIX - assumed 'TABLE_PREFIX' in /var/www/gallery-nathanr-ca/htdocs/_upgrade.php on line 237

Adding new field description to database. Notice: Use of undefined constant TABLE_PREFIX - assumed 'TABLE_PREFIX' in /var/www/gallery-nathanr-ca/htdocs/_upgrade.php on line 240

Adding new field theme_dir to database. Notice: Use of undefined constant TABLE_PREFIX - assumed 'TABLE_PREFIX' in /var/www/gallery-nathanr-ca/htdocs/_upgrade.php on line 243

Adding new field album_sortby to database. Notice: Use of undefined constant TABLE_PREFIX - assumed 'TABLE_PREFIX' in /var/www/gallery-nathanr-ca/htdocs/_upgrade.php on line 244

Adding new field album_sortdir to database. Notice: Use of undefined constant TABLE_PREFIX - assumed 'TABLE_PREFIX' in /var/www/gallery-nathanr-ca/htdocs/_upgrade.php on line 245

Adding new field collection_sortby to database. Notice: Use of undefined constant TABLE_PREFIX - assumed 'TABLE_PREFIX' in /var/www/gallery-nathanr-ca/htdocs/_upgrade.php on line 246

Adding new field collection_sortdir to database. Notice: Use of undefined constant TABLE_PREFIX - assumed 'TABLE_PREFIX' in /var/www/gallery-nathanr-ca/htdocs/_upgrade.php on line 250

Adding new field enable_thumb_nav to database. Notice: Use of undefined constant TABLE_PREFIX - assumed 'TABLE_PREFIX' in /var/www/gallery-nathanr-ca/htdocs/_upgrade.php on line 251

Adding new field thumb_nav_range to database.
Setting default theme directory to /var/www/gallery-nathanr-ca/htdocs/themes/default/

Reorganizing your images folder... Notice: Use of undefined constant TABLE_PREFIX - assumed 'TABLE_PREFIX' in /var/www/gallery-nathanr-ca/htdocs/_upgrade.php on line 282

Notice: Use of undefined constant TABLE_PREFIX - assumed 'TABLE_PREFIX' in /var/www/gallery-nathanr-ca/htdocs/_upgrade.php on line 285 Table 'nathan.TABLE_PREFIXcollections' doesn't exist

SELECT id,name FROM TABLE_PREFIXcollections

Change History

comment:1 Changed 13 months ago by nathanrdotca

Added: define("TABLE_PREFIX","plogger");

to plogger-config.php, that didn't help.

comment:2 Changed 13 months ago by nathanrdotca

Ah. I executed that script from the wrong folder. Errors are gone. Easy mistake to make.

The only remaining errors (on the plogger-admin interface) are: Deprecated: Function eregi() is deprecated in /var/www/gallery-nathanr-ca/htdocs/plog-includes/lib/phpthumb/phpthumb.functions.php on line 362

Warning: mysql_result() expects parameter 2 to be long, string given in /var/www/gallery-nathanr-ca/htdocs/plog-admin/plog-admin-functions.php on line 1133

Deprecated: Function split() is deprecated in /var/www/gallery-nathanr-ca/htdocs/plog-admin/plog-admin-functions.php on line 1961

Notice: Undefined index: JPG Support in /var/www/gallery-nathanr-ca/htdocs/plog-admin/plog-admin-functions.php on line 1977

comment:3 Changed 10 months ago by sidtheduck

Owner set to sidtheduck
Status changed from new to accepted

I have cleaned up the eregi, split, and all of the mysql_result notices in my current working localhost and these will be fixed at the next commit.

comment:4 Changed 9 months ago by sidtheduck

Status changed from accepted to closed
Resolution set to fixed

These should all be fixed as of revision r602.

Note: See TracTickets for help on using tickets.

Download in other formats: