Photo shop 1.3.1 and CPG 1.4.10 causes out of range error

[Willow69]

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 Expand

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

[Nibbler]

It should probably be 0 instead of ''. Try to find the query in the code and correct it.

[Nibbler]

May be here (photo_shop_config.php)

Code Select Expand

$priority = (is_numeric($temp[0])) ? ++$temp[0] : '';

Code Select Expand

$priority = (is_numeric($temp[0])) ? ++$temp[0] : 0;

[Willow69]

@Nibbler: That has been it 

Problem solved! - THANK YOU VERY MUCH!

Cheers,
Willow