Photo of the Day/Week, with Archive

[JaymzM]

Hello all, new to Coppermine and I must say it's awesome, thank you to everyone's hard work, Great Job.

I have been using the latest version and it works great (as long as you read all the doc's...learned the hard way)

I've been using the latest version of potw plugin, it loaded great, installed nice and loaded the first pic great.
However on the second week I went to change the potw, following the instructions closely I received this error

While executing query "REPLACE INTO babyrae_coppermine_siteplugin_potd (`pid`,`potw`,`potw_date`) VALUES ('178','1','1247542651')" on 0

mySQL error: Field 'potd_date' doesn't have a default value

File: C:\Inetpub\wwwroot\babyrae\include\functions.inc.php - Line: 250 

I went into mySQL and changed babyrae_coppermine_siteplugin_potd 'potw_date' to 'As Defined' and everything started working again.

Not sure if this will help anyone else but it worked for me, keep up the good work guys.

Jaymz 

[Joachim Müller]

You shouldn't be running mysql in strict mode unless you understand what that means.
To permanently fix that in your install, assign a default value to the column the error message complains about (using phpMyAdmin or similar). To permanently fix this is the plugin package, edit schema.sql, and replace the content with

Code:

CREATE TABLE IF NOT EXISTS `CPG_plugin_potd` (

  `pid` INT(11) NOT NULL,

  `potd` TINYINT(3) DEFAULT '0' NOT NULL,

  `potd_date`  varchar(14) DEFAULT '' NOT NULL,

  `potw` TINYINT(3) DEFAULT '0' NOT NULL,

  `potw_date`  varchar(14) DEFAULT '' NOT NULL,

PRIMARY KEY  (`pid`)

);

This will of course only have an impact if you uninstall and re-install the plugin.

[jimi007]

i also facing problem that no thumbnail shown for both potd/potw  what should i do plz help and tell how to manually add pictures to potd/potw archive thnkx i follow all step as in readme and also add hack to function file .

[Joachim Müller]

This is your ultimate and final warning: you have been told so often already about board rules that it hurts, e.g. in

Learn to respect board rules first.

You are banned from posting for a week. Next ban will be permanent if you don't play by the rules from now on.