Thanks!

[SoberNClean]

I just did it whooo hooo

I have to find someone to patch up the database for me with a current on that is working so I don't keep having the error on the first image all the time but other than that everything is working so I can live with the first image I guess if I need to whoo hooo




When you drop down the other menus everything is fine.



So I suppose that I can live with that issue I think not sure but I will send them to my Server guy who is pretty well respected around the parts of VB.com and here and I am sure he can fix it for me such a nice guy he is

Thanks for all of your patience with a silly ass such as myself. :D

[Steve Machol]

Strange. I don't see how that field could be missing. Try running these queries to drop and recreate the moderation table:

DROP TABLE IF EXISTS moderation;

CREATE TABLE moderation (
`primaryid` int(10) unsigned NOT NULL default '0',
`type` enum('thread','reply','visitormessage','groupmessa ge') NOT NULL default 'thread',
`dateline` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`primaryid`,`type`),
KEY `type` (`type`,`dateline`)
) TYPE=MyISAM;

[SoberNClean]

Strange. I don't see how that field could be missing. Try running these queries to drop and recreate the moderation table:

DROP TABLE IF EXISTS moderation;

CREATE TABLE moderation (
`primaryid` int(10) unsigned NOT NULL default '0',
`type` enum('thread','reply','visitormessage','groupmessa ge') NOT NULL default 'thread',
`dateline` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`primaryid`,`type`),
KEY `type` (`type`,`dateline`)
) TYPE=MyISAM;

LMAO ok whatever you said is like some other lingo than mine and I have no idea how to run a queries to drop or whatever ya said but that is cool unless you want to give me step by step instructions that a 5 year old can understand :rolleyes: I probably did something that I shouldn't have during the installation if you can actually believe that :)

[EvilAkuma]

Go to your myphpadmin and drop that table and create a new one.

Best Regards,

James

[syrus.xl]

If you're unfamilar with phpMyAdmin you can always enable SQL queries to be run from the vBulletin AdminCP. Just look in the includes/config.php file and enable your userid to run MySQL queries.

[dodgeboard.com]

Sober,

I thought I fixed this for you last night?

I ran those exact queries on your database yesterday. What happened since then?

[SoberNClean]

Oh yes you did fix it. I just didn't have any of the 3.7 yet so I downloaded it and ran it and now I have everything working except for that one page but other than that no big deal it is all running pretty smooth.

[dodgeboard.com]

I updated your config.php to run queries from the admincp when I was inthere the other day.

Go into your admincp, maintenance, Execute SQL query

In the large box paste this:


DROP TABLE IF EXISTS moderation

then hit continue

then go back to the large box and paste this:


CREATE TABLE moderation (
`primaryid` int(10) unsigned NOT NULL default '0',
`type` enum('thread','reply','visitormessage','groupmessa ge') NOT NULL default 'thread',
`dateline` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`primaryid`,`type`),
KEY `type` (`type`,`dateline`)
) TYPE=MyISAM

then hit continue

Then refresh your page.

THAT WILL FIX IT!

[SoberNClean]

I updated your config.php to run queries from the admincp when I was inthere the other day.

Go into your admincp, maintenance, Execute SQL query

In the large box paste this:


DROP TABLE IF EXISTS moderationthen hit continue

then go back to the large box and paste this:


CREATE TABLE moderation (
`primaryid` int(10) unsigned NOT NULL default '0',
`type` enum('thread','reply','visitormessage','groupmessa ge') NOT NULL default 'thread',
`dateline` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`primaryid`,`type`),
KEY `type` (`type`,`dateline`)
) TYPE=MyISAMthen hit continue

Then refresh your page.

THAT WILL FIX IT!
WOW how do you guys know all of this stuff? I am going to keep this stuff! I will copy it into a notepad and than put it into my flash drive so I don't loose stuff like this


Thanks

Oh yeah and BTW your profile on my site absolutely sucks :Dyou should take sometime and make it look nice :rolleyes: