Altered Database Tables, Now I need to unalter

Hangin' Around Joined: Mar 02, 2009 Posts: 48

Hey everyone. I was reading through the thread about the mod in the works to be able to modify your modules description and keywords. I saw a link in there back to a clan site that said it had another version of that mod. http://www.ravenphpscripts.com/postp130523.html#130523

Well, I downloaded it, and tried it.

It wasn't what I was looking for, so I re uploaded my original files. Problem is, I used the provided sql file to alter my tables. I just tried to post more content today, and Its not saving it. I checked the database and its not getting saved there.

Here is the sql provided with the mod.

Code:

ALTER TABLE nuke_pages_categories ADD parentid int(11) NOT NULL default '0';


ALTER TABLE nuke_pages_categories ADD allowflag tinyint(1) NOT NULL default '1';


ALTER TABLE nuke_pages_categories ADD corder int(6) NOT NULL default '0';


ALTER TABLE nuke_pages ADD ptime int(11) NOT NULL default '0';


ALTER TABLE nuke_pages ADD porder int(6) NOT NULL default '0';





ALTER TABLE nuke_pages_categories ADD npages int(6) NOT NULL default '5';


CREATE TABLE nuke_pages_config (


  allowCollapse tinyint(1) NOT NULL default '1',


  allowComment tinyint(1) NOT NULL default '0',


  npagespercat int(10) NOT NULL default '5',


  npagenew int(6) NOT NULL default '20',


  npagepop int(6) NOT NULL default '20',


  npagerate int(6) NOT NULL default '20',


  allowLanguage tinyint(1) NOT NULL default '1',


  PRIMARY KEY  (npagenew)


);


INSERT INTO nuke_pages_config VALUES (1, 0, 5, 20, 20, 20, 0);

Can someone help me get my database back to the way it should be?

Thanks.

Posted: Wed Apr 08, 2009 5:25 pm

Use Phpmyadmin and delete the fields that you added in pages_categories and pages. Drop the table pages_categories.

Or just reload from a backup.

Posted: Wed Apr 08, 2009 5:42 pm

fkelly wrote:

Use Phpmyadmin and delete the fields that you added in pages_categories and pages. Drop the table pages_categories.

Or just reload from a backup.

That did it, thanks for the help. I just get nervous when it comes to messing with the database.

Posted: Wed Apr 08, 2009 6:08 pm

It pays to "practice" with backups, restores, copying tables etc. For instance, you could copy the tables you are going to change to tables with another name. Then make the modifications and test. If things get fouled up delete the tables you modified and copy the other ones back. There are a zillion possibilities like that. You can also backup any tables you are going to modify. You just want to make sure that the site isn't active so that the tables you are working on don't get modified by users after you have backed them up.

Posted: Wed Apr 08, 2009 6:25 pm

That's my DB which I developed.
That hierarchical category model of contents module is the very first stone to jump upto 'more advanced CH-model of content module.'

Well, I don't know why my module is avilable in this site.
But, that's fine because I did not manage my site for last 1.5 years.
At any event, that module is 0.xx version but the recent version is 1.3.5 version with 2G bytes of contents pages.

Do you know Contents page cannot exceed purely 64kb?
That should be changed up to 2G. Why?
When I tried to add E-book style contents (more than 600 pages in print), I changed it.
The present CH-contents should be released because I came back.

Hm...
I had never uploaded my hack and modules in raven's site except for announcements. Who uploaded them to?
That's a puzzle.

Posted: Wed Apr 08, 2009 7:01 pm

I didn't get the mod from RavenPHPScripts. If you click the link I posted in my first post, You will see where I got it.

Posted: Wed Apr 08, 2009 7:38 pm

Oh, I see.
That's my misconstruing, if you are right.
Thank you for correcting me.

By the way, the new CH model of Content module is so pwoerful. How? I am running contents with more than 4 G text in my other site with selective HTML permission.

I will release 1.4.0 in publich when my site is trimmed again.

registered · Posted: Fri Apr 10, 2009 6:52 am

misterpat, not sure its what you want, but did you see the Content Plus module that is provided in the 2.3.x version of RavenNuke(tm)? It is in the AddOnFiles directory and replaces the old stodgy base *nuke version. We have an active developer on the team who maintains the code for it.

Posted: Fri Apr 10, 2009 8:40 am

I just tried that Content Plus module. Its not what I'm looking for either. The closest thing I think is close to what I want is the mod being worked on now in thread

http://www.ravenphpscripts.com/postp130523.html

Would be nice to specify a unique description and keywords for each page of content.