[Solved]: cant upgrade from 1.2.1 to 1.3

[Jon]

While executing query "SELECT cid, name, description, thumb FROM cpg11d_categories WHERE parent = ''  ORDER BY pos" on 0

mySQL error: Unknown column 'thumb' in 'field list'

Code Select Expand


Debug info
USER:

Array
(
    [ID] => 4b6dda2ff46e086d4462bcbc4312f923
    [am] => 1
    [liv] => Array
        (
            [0] => 5011
            [1] => 5012
            [2] => 5013
            [3] => 5031
            [4] => 1947
        )

    [lap] => 1
)

GET :

Array
(
)

POST :

Array
(
)


J.

[erikas]

ALTER was not checked! thank you 

@erikas: Can you ensure that the MySQL user in user for Coppermine has CREATE, ALTER, INSERT and DROP drivileges on the database

[Jon]

I downgraded back to 1.2.1 but can I get a response please?

J.

[hyperion]

Can you verify like erikas that you have all the necessary MySQL permissions?

[Jon]

The user has all permissions.

J.

[Incite]

I am having the same problem, it is quite frustrating!! I enabled debug mode. this is what the results were. If anyone could help me out that would be awesome!

Critical error

There was an error while processing a database query.


While executing query "SELECT cid, name, description, thumb FROM cpg11d_categories WHERE parent = ''  ORDER BY pos" on 0

mySQL error: Unknown column 'thumb' in 'field list'

[Joachim Müller]

Use a tool like phpMyAdmin and check your database. Does the categories table have the same structure as the screenshot I attached?

GauGau

[attachment deleted by admin]

[Incite]

yes it looks exactley the same.

[200366]

Same Problem to me.


Warning: Undefined index: user_group_list in /var/www/www.xxxxx.xx/myalbum/include/init.inc.php on line 273
Fatal error :

There was an error while processing a database query.

While executing query "SELECT MAX(group_quota) as disk_max, MIN(group_quota) as disk_min, MAX(can_rate_pictures) as can_rate_pictures, MAX(can_send_ecards) as can_send_ecards, MAX(upload_form_config) as ufc_max, MIN(upload_form_config) as ufc_min, MAX(custom_user_upload) as custom_user_upload, MAX(num_file_upload) as num_file_upload, MAX(num_URI_upload) as num_URI_upload, MAX(can_post_comments) as can_post_comments, MAX(can_upload_pictures) as can_upload_pictures, MAX(can_create_albums) as can_create_albums, MAX(has_admin_access) as has_admin_access, MIN(pub_upl_need_approval) as pub_upl_need_approval, MIN( priv_upl_need_approval) as  priv_upl_need_approval FROM cpg11d_usergroups WHERE group_id in (1)" on 0

mySQL error: Unknown column 'upload_form_config' in 'field list'



I can't finde an column called 'upload_form_config' in cpg11d_usergroups. Why?


TC

[Joachim Müller]

• make sure you're using cpg1.3.0 (stable), not cpg1.3.0beta
  
• make sure you have run update.php
  
• check your database with phpMyAdmin (or a similar tool) and have a look at the db: is the missing field from the query actually there? If possible, provide a similar screenshot I attached 3 postings ago

GauGau

[200366]

• I've installed the newest version cpg1.3.0(stable)

[li] I've run updated.php[/li]

[li] I can't finde the missing field in the db[/li][/list]


What about the update.php?

update.php   644

Is this right?

[attachment deleted by admin]

[Joachim Müller]

please attach the screenshot that is more readible, I'm an old man who forgot to bring his glasses along .
File permissions (CHMOD) of the update file shouldn't matter, 644 is fine on most webhosts. Check your permissions on the database: are you allowed to use ALTER TABLE, CREATE TABLE, INSERT, DELETE ?
If the fields that are supposed to be created during udpate are not in the database, try running the queries manually (to be found in /your_coppermine_folder/sql/update.sql - remember to change your coppermine table prefix in the queries accordingly).

GauGau

[200366]

hi .. old man 

please click on the attachment to see the full size   

I've fixed the problem.

The field names in my database are different than the update.sql.

Fieldname in my DB:       CPG_
Fiedlname in update.sql:  cpg11d_

But I had to do the changes manually. The script doesn`t work. 

Now it works.

Does anyone know if there is an update for the theme GIALLO?

[Joachim Müller]

please click on the attachment to see the full size  

OK, so you modified your attachment...

The field names in my database are different than the update.sql.

Fieldname in my DB:       CPG_
Fiedlname in update.sql:  cpg11d_

But I had to do the changes manually. The script doesn`t work.  

expected behaviour, since the update srcipt and the installer take different coppermine table prefixes into account. That's why I wrote

remember to change your coppermine table prefix in the queries accordingly).

Now it works.

glad you managed it

Does anyone know if there is an update for the theme GIALLO?

we have a strcit policy of "one question per thread" on this board. Don't hijack threads, not even the ones you started. Since your original issue is solved, this thread is tagged as [Solved]. Giallo hasn't been ported to cpg1.3 so far, be the first to do so - read the Guide Converting cpg1.2.x themes to cpg1.3.0 that came with your package of cpg1.3.0 as well. Do not post stuff related to theming on this thread!

GauGau

[jakobl]

Sorry to open this thread again! I seem to have the same problem when updating to 1.3.0 (stable).
I get exactly the same error:

There was an error while processing a database query.


While executing query "SELECT cid, name, description, thumb FROM cpg11d_categories WHERE parent = ''  ORDER BY pos" on 0

mySQL error: Unknown column 'thumb' in 'field list'

My database structure is looking like this (please see attachment):
thus I am missing the thumb-field.

The Mysql user has all permissions.

You can look at jati.dk/coppermine1.3.0/ for further info.

Any suggestions?

[attachment deleted by admin]

[Joachim Müller]

did you try the same fixes suggested earlier in this thread?

GauGau

[jakobl]

Now it works! Thanks a lot.
I had somehow messed with the update.php file so that it was the 1.2.1 file and not the 1.3.0!
Sorry for the inconvience