http://erikas.hakeris.lt
Warning: Undefined index: user_group_list in /home/erikas/www/include/init.inc.php on line 273
Fatal error :
There was an error while processing a database
???
Have you ran the update.php file?
clear install is working fine (erikas.hakeris.lt/test), but upgrade dont
Quote from: jack on June 11, 2004, 02:16:02 PM
Have you ran the update.php file?
The error you are getting indicates that your databse is still in the format for 1.2
Running update.php will fix that.
updade.php it did not help, I said that :-\\
Any more advices?
Quote from: jack on June 11, 2004, 02:58:31 PM
The error you are getting indicates that your databse is still in the format for 1.2
Running update.php will fix that.
Then are you sure you updated all files, including those in the sql directory?
:)
yes, all :) and made directory "edit" in the albums dir, and chmod and....
dont know what to do :( how to upgrade gallery whithout loosing the albums
now gallery is restored and running on cpg 1.2.1 again...
Quote from: Casper on June 11, 2004, 08:35:24 PM
Then are you sure you updated all files, including those in the sql directory?
I am having the same problem. I too have updated all the files except for config.inc.php and my albums directory, and have put in the edit folder. I have run the update.php file with no luck. Anybody have any ideas?
Thanks
If either of you have scrrenshot software, provide a screenshot of the update.php programs output. (The list of things it says it has done.)
Are you getting any error message?
What exactly happened when you ran the upgrade.php? Did you get a page telling you things had been done?
Can you give a link?
Yes, i get the same error discussed earlier. Update.php says that everythign is "already done"
http://gavin.keiners.com/update.php
Thanks for any help you might be able to provide.
Hmm .. all the additional '\' characters in there don't look right to me. Could be one of the PHP magic_quotes settings crewing things up.
I'll look into this closer later on tonight.
If you have access to the database, can you go into the config table, and turn the debug on?
this is a copy of update.php - http://erikas.hakeris.lt/upgrade.htm
and then error message:
***********
Warning: Undefined index: user_group_list in /home/erikas/www/include/init.inc.php on line 273
Fatal error :
There was an error while processing a database
***********
Quote from: Casper on June 12, 2004, 07:26:38 PM
Are you getting any error message?
What exactly happened when you ran the upgrade.php? Did you get a page telling you things had been done?
Can you give a link?
Well, I turned on debug, here's the output:
While executing query "SELECT extension, mime, content FROM cpg11d_filetypes;" on 0
mySQL error: Table 'sillygoat2.cpg11d_filetypes' doesn't exist
it can be viewed at http://gavin.keiners.com
I turned magic quotes off, that didn't seem to help
@erikas: Can you ensure that the MySQL user in user for Coppermine has CREATE, ALTER, INSERT and DROP drivileges on the database
After turning off magic quotes and running update about 2 or 3 more times, it finally worked.
The output did work when it finally quit inserting the extra /'s.
Thanks a bunch for your help
I'm having the same problem. After I did the upgrade it said that everything had already been done, then when I click the link to continue it goes to the gallery and says critical error: There was an error while processing a database query. Is there a fix for this, or how should I revert to 1.2.1?
Thanks.
Please turn on debug mode (you may have to do this in the database if you cannot browse to config.php) and post here the debug report.
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'
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.
ALTER was not checked! thank you :D
Quote from: jack on June 12, 2004, 08:36:00 PM
@erikas: Can you ensure that the MySQL user in user for Coppermine has CREATE, ALTER, INSERT and DROP drivileges on the database
I downgraded back to 1.2.1 but can I get a response please?
J.
Can you verify like erikas that you have all the necessary MySQL permissions?
The user has all permissions.
J.
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!
QuoteCritical 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'
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]
yes it looks exactley the same.
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
- 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
- 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]
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
hi .. old man ;)
please click on the attachment to see the full size ;D
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?
Quote from: 200366 on June 27, 2004, 12:22:09 PMplease click on the attachment to see the full size ;D
OK, so you modified your attachment...
Quote from: 200366 on June 27, 2004, 12:22:09 PMThe 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
Quote from: GauGau on June 26, 2004, 11:21:20 AMremember to change your coppermine table prefix in the queries accordingly).
Quote from: 200366 on June 27, 2004, 12:22:09 PMNow it works.
glad you managed it
Quote from: 200366 on June 27, 2004, 12:22:09 PMDoes 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 (http://coppermine.sourceforge.net/demo/docs/theme.htm) that came with your package of cpg1.3.0 as well. Do not post stuff related to theming on this thread!
GauGau
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/ (http://jati.dk/coppermine1.3.0/) for further info.
Any suggestions?
[attachment deleted by admin]
did you try the same fixes suggested earlier in this thread?
GauGau
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