gallery went from offline to a reset

[samo]

okay i had a problem because i made my gallery offline, but i couldn't view anypages as admin. anyway i read up on how to change back to online mode. there was this suggestion saying to go to phpmyadmin and edit the value of the config table. so i went onto my phpMyAdmin 2.7.0-pl2, clicked on cpg143_config then edited the VALUE field changing the value to '0'. Previously I believe it was '255' When I went to my gallery index page it asked me to log in but it didnt accept my username and password. also i noticed that my theme was no longer active and it was a default.

i typed in update.php and the top line update was

CREATE TABLE IF NOT EXISTS cpg143_sessions ( session_id varchar(40) NOT NULL default '', user_id int(11) default '0', time int(11) default NULL, remember int(1) default '0', PRIMARY KEY (session_id) ) TYPE=MyISAM COMMENT='Used to store sessions'

maybe that can help point out my mistake. if i could get some assistance asap that would be great. i promise myself that i will not try any funny business anymore because i realize that it backfires on me and i mess things up.

thanks again
Sam

[Nibbler]

A link would help. If it said 255 then you probably changed the db field length instead of the value.

[samo]

i'll try that thanks. http://lalaine-fans.com/gallery

[Nibbler]

Yup, you screwed up your config table. Restore it from a backup or search for other posts by me that explain how to regenerate the config table.

[samo]

how do you do that?

[samo]

maybe this will help too

[samo]

 

[Nibbler]

Restore your config table from a backup or search for other posts by me that explain how to regenerate the config table

[samo]

i dont think i have a backup. and i searched for "regenerate config table" and didn't get any good results

[Nibbler]

Empty your config table. Then open sql/basic.sql with a text editor, replace CPG_ with cpg143_, save it and import it with phpmyadmin. That will repopulate the table.

[samo]

ok i emptied and replaced. the importing is where im stuck at. i do not have that option. is it like 'insert'?

[Nibbler]

Go to 'SQL' and either paste in the contents of the file or use the upload form.

[samo]

oh yeah i uploaded basic.sql into the sql folder, but my gallery index is still default

[samo]

actually now my index says

There was an error while processing a database query

[Nibbler]

Edit the config table to switch debug mode on. Click browse, look for debug_mode in the name column and set the value column to 1 for that name.

[Joachim Müller]

oh yeah i uploaded basic.sql into the sql folder, but my gallery index is still default

erm, you uploaded? You were meant to edit the file, copy the contents, modify as suggested and paste it into the textfield on the sql query page of phpMyAdmin. Is this what you did? This is not the same as "uploading".

[samo]

ok i foun what you were saying nibbler. okay i had the original basic.sql in the sql folder along with the uploaded new basic.sql
i had renamed the original just in case. ok i deleted the new one i uploaded and renamed the original to its proper name
next i wen to myphpadmin and clicked on browse. i had the edited the basic.sql on my computer, found the 'import' option, and used the form to import the file. so then i went to edit debug_notice and changed the value to 1.

yeah my site is still defaulted.
http://lalaine-fans.com/gallery

[Nibbler]

You don't have default settings - you have *no* settings, that is the problem. Don't use import, copy/paste the lines from the file into the SQL box.

[samo]

ok done, but still no change

[samo]

if i dl cpg143 again and just overwrite the basic.sql file by uploading the dl-ed one, will that screw up my database?