Print

[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]

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]

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

Code: [Select]

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

[Willow69]

@Nibbler: That has been it 

Problem solved! - THANK YOU VERY MUCH!

Cheers,
Willow