2.0.2 messed up my theme

w1zer

Joined: 2005-09-26
Posts: 37
Posted: Mon, 2006-01-16 12:22

I have just upgraded from G2 to G2.0.2 But it seems to have messed up the PGtheme. I have tried changing the theme but it still displays the same error message on the main page (root):

Configuration Error: Missing Theme
Missing Theme

This album is configured to use the PGtheme theme, but it is either inactive, not installed, or incompatible. To fix this problem you can install or activate this theme or select another default theme.


Gallery version (not just "2"): 2.0.2
PHP version (e.g. 4.3.11):
PHPInfo Link (see FAQ):
Webserver (e.g. Apache 1.3.33):
Database (e.g. MySql 4.0.11):
Activated toolkits (e.g. NetPbm, GD):
Operating system (e.g. Linux): Linux
Browser (e.g. Firefox 1.0): FF1.0.7
 
valiant

Joined: 2003-01-04
Posts: 32509
Posted: Mon, 2006-01-16 12:41

please download the latest pgtheme to your themes directory.
 
w1zer

Joined: 2005-09-26
Posts: 37
Posted: Mon, 2006-01-16 12:50

I have tried this and the same error occours
 
valiant

Joined: 2003-01-04
Posts: 32509
Posted: Mon, 2006-01-16 13:02

what was your previous g2 version? i don't think it was 2.0. i guess it was a beta or release candidate.

you'll have to edit your database manually because the pg theme changed its name. pg <-> pgtheme.
edit the g2_PluginMap table, remove the pg rows.
edit the g2_PluginParameterMap table, reove the pg rows. change the row
update g2_PluginParameterMap SET g_parameterValue = 'matrix'
WHERE g_pluginType = 'module, g_pluginId = 'core' AND g_parameterName = 'default.theme';

then delete the db cache by browsing to yourGallery.com/lib/support/ enter your password, click there on cache and delete the db and template cache.

if that doesn't help, do the following:

download the latest nightly snapshot of g2.
again enter the upgrader. upgrade the core module. if you then still get the missing theme warning in the upgrade other modules step, just browse to main.php and you should get the option to change the default theme.
 
w1zer

Joined: 2005-09-26
Posts: 37
Posted: Mon, 2006-01-16 13:28

I'm sorry valiant but that's flown over my head a bit. I had a look in phpMyAdmin 2.6.4-pl2 and selected gallery2 from the drop down list, clicked g2_PluginMap but after that I am a bit confused. What do you mean by 'remove the pg rows'?
 
valiant

Joined: 2003-01-04
Posts: 32509
Posted: Mon, 2006-01-16 13:32

remove the rows that have g_pluginId = pg or pgtheme.
 
w1zer

Joined: 2005-09-26
Posts: 37
Posted: Mon, 2006-01-16 13:42

sorry I stil do not understand what you mean. What are rows? how do I remove them?

 
valiant

Joined: 2003-01-04
Posts: 32509
Posted: Mon, 2006-01-16 16:26

just execute these three queries:

delete from g2_PluginMap WHERE g_pluginId IN ('PGtheme', 'pg');

delete from g2_PluginParameterMap WHERE g_pluginId IN ('PGtheme', 'pg');

update g2_PluginParameterMap SET g_parameterValue = 'matrix' WHERE g_pluginType = 'module' AND g_pluginId = 'core' AND g_parameterName = 'default.theme';

then delete the db cache by browsing to yourGallery.com/lib/support/ enter your password, click there on cache and delete the db and template cache.
 
w1zer

Joined: 2005-09-26
Posts: 37
Posted: Mon, 2006-01-16 17:24

Valiant, what you are suggesting just does not make sense to me. I do not understand how to do what you are suggesting. How do I execute a query?

Thanks for your help but plase bare in mind that I am not a web developer.
 
valiant

Joined: 2003-01-04
Posts: 32509
Posted: Mon, 2006-01-16 17:39

as you said you're using phpmyadmin. in phpmyadmin you can execute a sql query with the input field in the SQL tab.
 
w1zer

Joined: 2005-09-26
Posts: 37
Posted: Mon, 2006-01-16 18:36

MySQL said: Documentation
#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 'WHERE g_pluginType = 'module, g_pluginId = 'core' AND g_parameterName = 'default' at line 1

 
w1zer

Joined: 2005-09-26
Posts: 37
Posted: Mon, 2006-01-16 18:40

I skipped that line and did the rest. Then went to /lib/support/ cleared the cache and got the following:

http://www.wizer.co.uk/gallery2
 
valiant

Joined: 2003-01-04
Posts: 32509
Posted: Mon, 2006-01-16 19:01

i've updated my previous post. please the 3 queries again.
 
valiant

Joined: 2003-01-04
Posts: 32509
Posted: Mon, 2006-01-16 19:02

and don't forget to clear the template cache afterwards.
 
w1zer

Joined: 2005-09-26
Posts: 37
Posted: Mon, 2006-01-16 19:14

ok we got a bit further, that went fine but when IU tried to clear the cache, I got the following:

Warning: opendir(/home/wizer/g2data//cache/module/_all) [function.opendir]: failed to open dir: Permission denied in /home/wizer/public_html/gallery2/lib/support/cache.php on line 23

Warning: opendir(/home/wizer/g2data//cache/module/rewrite) [function.opendir]: failed to open dir: Permission denied in /home/wizer/public_html/gallery2/lib/support/cache.php on line 23

Warning: opendir(/home/wizer/g2data//cache/module/geturls) [function.opendir]: failed to open dir: Permission denied in /home/wizer/public_html/gallery2/lib/support/cache.php on line 23

Warning: opendir(/home/wizer/g2data//cache/module/albumselect) [function.opendir]: failed to open dir: Permission denied in /home/wizer/public_html/gallery2/lib/support/cache.php on line 23

Warning: opendir(/home/wizer/g2data//cache/module/archiveupload) [function.opendir]: failed to open dir: Permission denied in /home/wizer/public_html/gallery2/lib/support/cache.php on line 23

Warning: opendir(/home/wizer/g2data//cache/module/captcha) [function.opendir]: failed to open dir: Permission denied in /home/wizer/public_html/gallery2/lib/support/cache.php on line 23

Warning: opendir(/home/wizer/g2data//cache/module/cart) [function.opendir]: failed to open dir: Permission denied in /home/wizer/public_html/gallery2/lib/support/cache.php on line 23

Warning: opendir(/home/wizer/g2data//cache/module/colorpack) [function.opendir]: failed to open dir: Permission denied in /home/wizer/public_html/gallery2/lib/support/cache.php on line 23

Got about 50 lines of this.
 
valiant

Joined: 2003-01-04
Posts: 32509
Posted: Mon, 2006-01-16 19:22

then your filesystem permissions are incorrect.
ask your webhost to
chmod -R 777 /home/wizer/g2data/
 
w1zer

Joined: 2005-09-26
Posts: 37
Posted: Mon, 2006-01-16 20:03

Got a bit further, it cleared the cache successfully but now it says access denied on the gallery2 directory. I have looked and the permissions are set to 777 also?

Now the images that I had linked from my gallery are now showing? Whats happening?
 
w1zer

Joined: 2005-09-26
Posts: 37
Posted: Mon, 2006-01-16 20:03

PS: I have shell access
 
valiant

Joined: 2003-01-04
Posts: 32509
Posted: Mon, 2006-01-16 22:58

what's the exact error / message you get when you browse to gallery/main.php?
 
w1zer

Joined: 2005-09-26
Posts: 37
Posted: Tue, 2006-01-17 06:29

Internal Server Error
The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator,

and inform them of the time the error occurred, and anything you might have done that may have caused the error.

More information about this error may be available in the server error log.

Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.
Apache/1.3.34 Server at www.wizer.co.uk Port 80
 
valiant

Joined: 2003-01-04
Posts: 32509
Posted: Tue, 2006-01-17 10:11

please check your apache server error log.
 
w1zer

Joined: 2005-09-26
Posts: 37
Posted: Tue, 2006-01-17 10:24

[2006-01-17 05:21:16]: error: file is writable by others: (/home/wizer/public_html/gallery2/main.php)
[2006-01-17 05:21:16]: error: file is writable by others: (/home/wizer/public_html/gallery2/main.php)
[2006-01-17 05:21:16]: error: file is writable by others: (/home/wizer/public_html/gallery2/main.php)
[2006-01-17 05:21:15]: error: file is writable by others: (/home/wizer/public_html/gallery2/main.php)
[2006-01-17 05:21:15]: error: file is writable by others: (/home/wizer/public_html/gallery2/main.php)
[2006-01-17 05:21:15]: error: file is writable by others: (/home/wizer/public_html/gallery2/main.php)
[2006-01-17 05:21:15]: error: file is writable by others: (/home/wizer/public_html/gallery2/main.php)
[Tue Jan 17 05:21:18 2006] [error] [client 132.185.144.120] File does not exist: /home/wizer/public_html/404.shtml
[Tue Jan 17 05:21:18 2006] [error] [client 132.185.144.120] File does not exist: /home/wizer/public_html/favicon.ico
[Tue Jan 17 05:21:16 2006] [error] [client 132.185.144.122] File does not exist: /home/wizer/public_html/500.shtml
[Tue Jan 17 05:21:16 2006] [error] [client 132.185.144.122] Premature end of script headers: /home/wizer/public_html/gallery2/main.php
[Tue Jan 17 05:21:16 2006] [error] [client 132.185.144.122] File does not exist: /home/wizer/public_html/500.shtml
[Tue Jan 17 05:21:16 2006] [error] [client 132.185.144.122] Premature end of script headers: /home/wizer/public_html/gallery2/main.php
[Tue Jan 17 05:21:16 2006] [error] [client 132.185.144.120] File does not exist: /home/wizer/public_html/500.shtml
[Tue Jan 17 05:21:16 2006] [error] [client 132.185.144.120] Premature end of script headers: /home/wizer/public_html/gallery2/main.php
[Tue Jan 17 05:21:16 2006] [error] [client 132.185.144.120] File does not exist: /home/wizer/public_html/500.shtml
[Tue Jan 17 05:21:16 2006] [error] [client 132.185.144.120] Premature end of script headers: /home/wizer/public_html/gallery2/main.php
[Tue Jan 17 05:21:16 2006] [error] [client 132.185.144.120] File does not exist: /home/wizer/public_html/500.shtml
[Tue Jan 17 05:21:16 2006] [error] [client 132.185.144.120] Premature end of script headers: /home/wizer/public_html/gallery2/main.php
[Tue Jan 17 05:21:16 2006] [error] [client 132.185.144.120] File does not exist: /home/wizer/public_html/500.shtml
[Tue Jan 17 05:21:16 2006] [error] [client 132.185.144.120] Premature end of script headers: /home/wizer/public_html/gallery2/main.php
[Tue Jan 17 05:21:15 2006] [error] [client 132.185.144.120] File does not exist: /home/wizer/public_html/500.shtml
[Tue Jan 17 05:21:15 2006] [error] [client 132.185.144.120] Premature end of script headers: /home/wizer/public_html/gallery2/main.php
[Tue Jan 17 03:03:39 2006] [error] [client 66.249.65.109] File does not exist: /home/wizer/public_html/404.shtml
[Tue Jan 17 03:03:39 2006] [error] [client 66.249.65.109] File does not exist: /home/wizer/public_html/robots.txt
[Tue Jan 17 02:58:07 2006] [error] [client 66.249.65.109] File does not exist: /home/wizer/public_html/404.shtml
[Tue Jan 17 02:58:07 2006] [error] [client 66.249.65.109] script not found or unable to stat: /home/wizer/public_html/wp-polls.php
[Tue Jan 17 02:15:08 2006] [error] [client 84.66.241.185] File does not exist: /home/wizer/public_html/500.shtml
[Tue Jan 17 02:15:08 2006] [error] [client 84.66.241.185] Premature end of script headers: /home/wizer/public_html/gallery2/main.php
[Tue Jan 17 02:15:08 2006] [error] [client 84.66.241.185] File does not exist: /home/wizer/public_html/500.shtml
[Tue Jan 17 02:15:08 2006] [error] [client 84.66.241.185] Premature end of script headers: /home/wizer/public_html/gallery2/main.php
[Tue Jan 17 02:15:08 2006] [error] [client 84.66.241.185] File does not exist: /home/wizer/public_html/500.shtml
[Tue Jan 17 02:15:08 2006] [error] [client 84.66.241.185] Premature end of script headers: /home/wizer/public_html/gallery2/main.php
[Tue Jan 17 02:15:08 2006] [error] [client 84.66.241.185] File does not exist: /home/wizer/public_html/500.shtml
[Tue Jan 17 02:15:08 2006] [error] [client 84.66.241.185] Premature end of script headers: /home/wizer/public_html/gallery2/main.php
[Tue Jan 17 02:15:08 2006] [error] [client 84.66.241.185] File does not exist: /home/wizer/public_html/500.shtml
 
w1zer

Joined: 2005-09-26
Posts: 37
Posted: Tue, 2006-01-17 10:25

there is a lot more like that
 
valiant

Joined: 2003-01-04
Posts: 32509
Posted: Tue, 2006-01-17 11:06

please check:
FAQ: How can I make sure that my installation files are all intact?

and please post a phpinfo link.
 
w1zer

Joined: 2005-09-26
Posts: 37
Posted: Tue, 2006-01-17 13:34

Thank you very much for trying to help me but it was making no sense what so ever. I decided to reinstall Gallery2 and now have it back up and running. Is there a way to import the backup albums folder to g2data or do I have to reupload all the images.
 
valiant

Joined: 2003-01-04
Posts: 32509
Posted: Tue, 2006-01-17 13:44

FAQ: How can I export data from one G2 to another G2 installation?