4.2.3 install and SQLSTATE[23000]

[Andre Vanderlynden]

Hello,
i just install 4.2.3 (i usually install svn every day but this time i did not install any file since Dec the 23. (some error must come from those new files)

individual.php does no longer show any thing under tabs (only th général header and indi header and menu but no tabs at all)
and i get the rror below when going to either place function (admin googlemap / place list ….)

Many of the places i use have diacritic characters and about all have ( and ) characters.

well could somebody please give me help

Thanks,

André

exception 'PDOException' with message 'SQLSTATE: Integrity constraint violation: 1048 Column 'site_setting_value' cannot be null' in /home/vdlynden/public_html/genealogie/includes/classes/class_pgv_db.php:830 Stack trace: #0 : PDOStatement->execute(Array) #1 /home/vdlynden/public_html/genealogie/includes/classes/class_pgv_db.php(830): call_user_func_array(Array, Array) #2 : PGV_DBStatement->__call('execute', Array) #3 /home/vdlynden/public_html/genealogie/includes/functions/functions_db.php(2396): PGV_DBStatement->execute(Array) #4 /home/vdlynden/public_html/genealogie/modules/googlemap/db_schema/db_schema_1_2.php(64): set_site_setting('GM_PH_XSIZE', NULL) #5 /home/vdlynden/public_html/genealogie/includes/classes/class_pgv_db.php(777): require('/home/vdlynden/…') #6 /home/vdlynden/public_html/genealogie/modules/googlemap/defaultconfig.php(35): PGV_DB::updateSchema('./modules/googl…', 'GM_SCHEMA_VERSI…', 2) #7 /home/vdlynden/public_html/genealogie/modules/googlemap/placehierarchy.php(34): require('/home/vdlynden/…') #8 /home/vdlynden/public_html/genealogie/placelist.php(30): require('/home/vdlynden/…') #9 {main}

[Greg Roach]

> i just install 4.2.3

Are you sure?  This error looks like it came from 4.3.0svn.

[Andre Vanderlynden]

Hello Greg,
really happy you're here around.
my version is revision 6631

what i allways do is a
svn co https://phpgedview.svn.sourceforge.net/svnroot/phpgedview/trunk/phpGedView /home/andre/Documents/repertoires_svn/phpgedview

and then copy newest files to my website.

did i mistake ?

How should i do to only get last stable version with its corrections ?

If that's wrong, how do i go back to 4.2.3 if possible ?

Thanks,
André

[Greg Roach]

Andre,

Using SVN does risk the occaisional glitch like this, but we try to fix any problems ASAP.

Try deleting (or renaming) your modules/googlemap/config.php file.

What DB are you using (MySQL?).  Do you use googlemap?

[Greg Roach]

Or, you could just update to latest SVN.

I believe I have found and fixed the problem.

Earlier versions of the googlemap config file had a different format to the later ones.

[Andre Vanderlynden]

Hello Greg,

> Using SVN does risk the occaisional glitch like this, but we try to fix any problems ASAP.

So that's why i usually use it and never had a pb !

> What DB are you using (MySQL?). Do you use googlemap?

I use MySQL and Googlemap

> Try deleting (or renaming) your modules/googlemap/config.php file.

i just tried it and it immedialty worked.
All setup data was immediatly recovered in newly created confi.php file
I just had to change "Enable GoogleMap" to yes again and every think seems ok again.

Great help, **i thank you really very much**.

André