Oh no! Where's the JavaScript?
Your Web browser does not have JavaScript enabled or does not support JavaScript. Please enable JavaScript on your Web browser to properly view this Web site, or upgrade to a Web browser that does support JavaScript.
Sign In
Not a member yet? Click here to register.

0.307->1.200 Upgrade Problem (Photo Gallery)

i already follow the instruction again and i already succesfull upgrade my forum (www.d-bests.com) finally :D But..... there's a problem with photogallery... i already run photo setting after upgrade it and then photo converter infusion. but when i convert it there's an error

this message appear in photo gallery:

Quote

Unknown column 'album_access' in 'where clause'


and this one apeear in admin panel photo gallery :

Quote

Unknown column 'ta.album_user' in 'on clause'Unknown column 'ta.album_user' in 'on clause'


Thx for reading my problem ;)
It looks like you need to CHMOD 777 the photogallery as per the instructions. Let me know if that doesn't solve it.
i'll test it soon :)
deaw5227, you need to CHMOD the appropirate folder and files in the installation process! Otherwise, things don't function properly.
err 1 thing -_- since i'm a newbie in here. how to change a CHMOD ? *sorry*

i just simply upload all things except setup.php and the photogallery folder itself in image folder already CHMODed into 777, but not in inner folder
No problem - everyone is a newbie at some point! I made up A Guide covering some of your questions... check it out and let me know if you still can't CHMOD the files ;)

okay now i already CHMOD the folder and the files :) (yay now i can do CHMOD , lol)

but still it not working :( , the photo gallery still say like first :(

any another idea ?
Database issue, we need a dump of your db structure.
ummm... please email it to Digi! Don't post it ;)
Once again >.< err... how to do that ? (Getting DUMP) i'll send it to digi soon as i know how to get it x_x
aye² doing it right away XD
err. looks like it was the same way to just database backup isn't it ? or maybe i'm wrong x_x
No big deal, feel free to PM me your access info and I can get the dump for Nick.

;)
okay now. i've make a db DUMP. what's digi's e-mail ? or maybe i just send it via PM with downloadable link of my db DUMP ? x_x. or maybe i can send it to you :)
Would be best to email him the dump. Click his profile... click his email button! ;)
oki :)
already sent it to digi,

thx for your support aquarian :D
No problemo... ;)
Yep db issue, goto admin -> custom pages, paste this and preview

CodeDownload  
<?php
$result = dbquery("DROP TABLE ".$db_prefix."old_photo_albums");
$result = dbquery("DROP TABLE ".$db_prefix."old_photos");
$result = dbquery("ALTER TABLE ".$db_prefix."photo_albums RENAME ".$db_prefix."old_photo_albums");
$result = dbquery("ALTER TABLE ".$db_prefix."photos RENAME ".$db_prefix."old_photos");
// Create new photo_albums table
$result = dbquery("CREATE TABLE ".$db_prefix."photo_albums (
album_id SMALLINT(5) UNSIGNED NOT NULL AUTO_INCREMENT,
album_title VARCHAR(100) NOT NULL DEFAULT '',
album_description TEXT NOT NULL,
album_thumb VARCHAR(100) NOT NULL DEFAULT '',
album_user SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
album_access SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
album_order SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
album_datestamp INT(10) UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY (album_id)
) TYPE=MyISAM;");
// Create new photos table         
$result = dbquery("CREATE TABLE ".$db_prefix."photos (
photo_id SMALLINT(5) UNSIGNED NOT NULL AUTO_INCREMENT,
album_id SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
photo_title VARCHAR(100) NOT NULL DEFAULT '',
photo_description TEXT NOT NULL,
photo_filename VARCHAR(100) NOT NULL DEFAULT '',
photo_thumb1 VARCHAR(100) NOT NULL DEFAULT '',
photo_thumb2 VARCHAR(100) NOT NULL DEFAULT '',
photo_datestamp INT(10) UNSIGNED NOT NULL DEFAULT '0',
photo_user SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
photo_views SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
photo_order SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
photo_allow_comments tinyint(1) unsigned NOT NULL default '1',
photo_allow_ratings tinyint(1) unsigned NOT NULL default '1',
PRIMARY KEY (photo_id)
) TYPE=MyISAM;");
echo "updates complete.";
?>

Thread Information
Author
Replies
23 posts
Views
5230 times
Last Post
Last updated on 13 years ago
Related Threads
You can view all discussion threads in this forum.
You can start a new discussion thread in this forum.
You cannot reply in this discussion thread.
You cannot start on a poll in this forum.
You cannot upload attachments in this forum.
You cannot download attachments in this forum.