search

geodesicsolutions-community / geocore-community

GeoCore Community, open source classifieds and auctions software
MIT License
9 stars 6 forks source link

Critical errors upgrading from v7.5.2 #187

Closed vicos59 closed 1 year ago

vicos59 commented 1 year ago

@jonyo, I wish I would have run a test upgrade sooner. In any case:

upgrade screen

It fails hard on 7.5.3 -> 7.6.0

error-1

From the looks of it, the problem is because mySQL is running in strict mode and thus default values are required for all fields.

vicos59 commented 1 year ago

So, the table is:

geodesic_upgrade_queries

I updated the table to set the DEFAULT to NULL (which is what you see above. There was no default value before.

Anyway, that moves us along to the next error:

error-2

This is the statement that is trying to execute from updateFactory.php:

result_sql, line 828: REPLACE INTOgeodesic_upgrade_queriesSETquery_id=1,strict=0,status=-1

which sure enuf produces an error in SQL:

error-3

The correct SQL requires that status be quoted:

REPLACE INTOgeodesic_upgrade_queriesSETquery_id=1,strict=0,status='-1'

jonyo commented 1 year ago

Make sure you set strict mode to true in config, I think that is default though.

(Just to rule that out)

That is a pretty old update though so wouldn't be surprised if it doesn't play nice.

vicos59 commented 1 year ago

Make sure you set strict mode to true in config, I think that is default though.

Yep, mine is set to '0'

Let me change and try again.

vicos59 commented 1 year ago

ha ha, yep. That was the issue. Thanks @jonyo

If only you could have seen the look of disappointment on my face when that error popped up. Like a sad hound dog.

The domain was moved from an old server which didn't use strict mode.