forum.coppermine-gallery.net

Support => cpg1.4.x Support => Older/other versions => cpg1.4 plugins => Topic started by: Willow69 on December 11, 2006, 03:14:54 pm

Title: Photo shop 1.3.1 and CPG 1.4.10 causes out of range error
Post by: Willow69 on December 11, 2006, 03:14:54 pm
Hi everyone,

if just installed the photo shop 1.3.1 plugin and receive the following error while trying to configure the shop:

Code: [Select]
While executing query "INSERT INTO cpg149_shop_config (priority) VALUES ('')" on 0

mySQL error: Out of range value adjusted for column 'priority' at row 1

This error mesage comes up when I press the "new format" button in the config screen.
I've already emptied the database tables and tried update.php.

The miniCMS plugin was installed but now has been removed (dosn't seem to make any difference because the error msg remains the same)...

Any clues?

THX in advance,
Willow
Title: Re: Photo shop 1.3.1 and CPG 1.4.10 causes out of range error
Post by: Nibbler on December 11, 2006, 03:21:49 pm
It should probably be 0 instead of ''. Try to find the query in the code and correct it.
Title: Re: Photo shop 1.3.1 and CPG 1.4.10 causes out of range error
Post by: Nibbler on December 11, 2006, 03:23:40 pm
May be here (photo_shop_config.php)

Code: [Select]
$priority = (is_numeric($temp[0])) ? ++$temp[0] : '';
Code: [Select]
$priority = (is_numeric($temp[0])) ? ++$temp[0] : 0;
Title: Re: Photo shop 1.3.1 and CPG 1.4.10 causes out of range error
Post by: Willow69 on December 11, 2006, 04:20:59 pm
@Nibbler: That has been it  ;D

Problem solved! - THANK YOU VERY MUCH!

Cheers,
Willow