Piwigo.org

mbaumser · 2009-03-26 20:22:49

i'm getting the following error messages,

Notice: Undefined index: level in /home/mkbconsu/public_html/gallery/include/functions_user.inc.php on line 313

Warning: [mysql error 1064] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 4

SELECT DISTINCT(id)
FROM phpwebgallery_images INNER JOIN phpwebgallery_image_category ON id=image_id
WHERE category_id NOT IN (0)
AND level> in /home/mkbconsu/public_html/gallery/include/functions.inc.php on line 919

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/mkbconsu/public_html/gallery/include/functions.inc.php on line 937

Notice: Undefined index: level in /home/mkbconsu/public_html/gallery/include/functions_user.inc.php on line 591

Warning: [mysql error 1064] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'GROUP BY c.id' at line 8
SELECT c.id cat_id, global_rank,
MAX(date_available) date_last, COUNT(date_available) nb_images
FROM phpwebgallery_categories as c
LEFT JOIN phpwebgallery_image_category AS ic ON ic.category_id = c.id
LEFT JOIN phpwebgallery_images AS i
ON ic.image_id = i.id
AND i.level<=
GROUP BY c.id in /home/mkbconsu/public_html/gallery/include/functions.inc.php on line 919

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/mkbconsu/public_html/gallery/include/functions_user.inc.php on line 610

Warning: [mysql error 1054] Unknown column 'cache_update_time' in 'field list'

INSERT INTO phpwebgallery_user_cache
(user_id, need_update, cache_update_time, forbidden_categories, nb_total_images,
image_access_type, image_access_list)
VALUES
(2,'false',1238095188,'0',3021,"NOT IN","0")
; in /home/mkbconsu/public_html/gallery/include/functions.inc.php on line 919

Warning: Cannot modify header information - headers already sent by (output started at /home/mkbconsu/public_html/gallery/include/functions_user.inc.php:313) in /home/mkbconsu/public_html/gallery/include/page_header.php on line 98

VDigital · 2009-03-26 21:07:16

MySQL server version ?

Warning: [mysql error 1054] Unknown column 'cache_update_time' in 'field list'
Maybe Migration failed. Did you follow the Upgrade Guide?

mbaumser · 2009-03-26 22:05:14

VDigital wrote:
MySQL server version ?

Warning: [mysql error 1054] Unknown column 'cache_update_time' in 'field list'
Maybe Migration failed. Did you follow the Upgrade Guide?

MYSQL is 5.0.75

I did follow the guide. I've since reverted back to my previous version to get things working again.

I'll try again in a couple of days when I have more time.

When I do the upgrade, does it modify my existing tables or should I be creating new tables within the same DB?

plg · 2009-03-27 00:27:42

During upgrade, did you run upgrade.php script? (it looks so much like it is the problem, I ask nearly the same question as VDigital)

mbaumser wrote:
When I do the upgrade, does it modify my existing tables or should I be creating new tables within the same DB?

upgrade.php modify existing tables.

mbaumser · 2009-03-27 12:00:23

plg wrote:
During upgrade, did you run upgrade.php script? (it looks so much like it is the problem, I ask nearly the same question as VDigital)

mbaumser wrote:
When I do the upgrade, does it modify my existing tables or should I be creating new tables within the same DB?
upgrade.php modify existing tables.

No. That is clearly the problem.

I must have miss understood the upgrade guide. after I uploaded all the new files, I went to my gallery and the new version asked questions as if doing a new install. was I instead supposed to go to ...gallery/upgrade.php instead?

Marc

VDigital · 2009-03-27 14:21:27

Please RTFM

Be sure your old mysql.inc.php and config are there... (Step 5)
Run Upgrade.php (Step 7)

mbaumser · 2009-03-27 16:20:21

VDigital wrote:
Please RTFM

Be sure your old mysql.inc.php and config are there... (Step 5)
Run Upgrade.php (Step 7)

I don't see include/config_local.inc.php
I have include/config_default.inc.php

is this the same?

I tried running upgrade.php

and got this

/templates_c no write access

#1 mkgetdir /home/mkbconsu/public_html/gallery/include/template.class.php(61)
#2 Template::Template /home/mkbconsu/public_html/gallery/upgrade.php(178)

Last edited by mbaumser (2009-03-27 16:35:49)

VDigital · 2009-03-27 18:59:41

local is local and not global. If you don't have it you skip.

for _data/templates_c subdirectory
change rights to
chmod 755 (drwxr-xr-x) or chmod 777 (drwxrwxrwx)

mbaumser · 2009-03-27 20:12:39

success!!

thanks for your help and patience.

Marc

Piwigo.org

Announcement

#1 2009-03-26 20:22:49

[resolved] errors after upgrade to 2.0

#2 2009-03-26 21:07:16

Re: [resolved] errors after upgrade to 2.0

#3 2009-03-26 22:05:14

Re: [resolved] errors after upgrade to 2.0

VDigital wrote:

#4 2009-03-27 00:27:42

Re: [resolved] errors after upgrade to 2.0

mbaumser wrote:

#5 2009-03-27 12:00:23

Re: [resolved] errors after upgrade to 2.0

plg wrote:

mbaumser wrote:

#6 2009-03-27 14:21:27

Re: [resolved] errors after upgrade to 2.0

#7 2009-03-27 16:20:21

Re: [resolved] errors after upgrade to 2.0

VDigital wrote:

#8 2009-03-27 18:59:41

Re: [resolved] errors after upgrade to 2.0

#9 2009-03-27 20:12:39

Re: [resolved] errors after upgrade to 2.0

Board footer