Need some php help! PLS!!!

konjini · Feb 3, 2003, 04:04 PM

http://www.clanhgs.com/forum/portal.php?page=1
I've installed the stats mod and now i'm getting that error for the portal page.

UberLord · Feb 3, 2003, 04:34 PM

Looks like the stats mod has removed a vital table. I suggest rolling the database and forum scripts back to a working backup and reporting the bug with the mod makers.

You do keep backups dont you? And doing a full backup before any major changes?

konjini · Feb 3, 2003, 04:47 PM

Ya i've made a beckup and contacted the maker from the mod.
But the think is the forum is working allright it's just something in the portal function's.
It looks to me that the portal sql shude be added if i look to this:

Code:

CREATE TABLE phpbb_portal ( 
portal_id mediumint(8) auto_increment NOT NULL, 
portal_order mediumint(8) NOT NULL, 
portal_title varchar(60) NOT NULL, 
portal_description text NULL, 
portal_bbcode_id varchar(10) NOT NULL, 
portal_use_url tinyint(1) NULL, 
portal_forum mediumint(8) NOT NULL, 
portal_url varchar(250) NOT NULL, 
portal_list_limit mediumint(8) NOT NULL, 
portal_ascending tinyint(1) NULL, 
portal_nodate tinyint(1) NULL, 
portal_button_name varchar(100) NOT NULL, 
portal_button_image varchar(100) NOT NULL, 
portal_navbar tinyint(1) NULL, 
portal_login tinyint(1) NULL, 
portal_online tinyint(1) NULL, 
portal_latest tinyint(1) NULL, 
portal_poll tinyint(1) NULL, 
PRIMARY KEY (portal_id) 
)

I'm just a rookie on this feeld so it's just some speculations.

konjini · Feb 3, 2003, 04:58 PM

The NutPortal

Stats Mod

UberLord · Feb 3, 2003, 06:20 PM

Yeah, that SQL code will create the table you need

konjini · Feb 3, 2003, 08:54 PM

Aaaa crap wtf...traying to roll beck the beckup i've made for the sql and it's refusing it.
Just fucking great

.

SQL code is from the portal it self, the original but i'm quasing ther shude be something added about that stats thing in ther.

Me feels like killing someone and getting beck to DeluxPortal afther that

.

konjini · Feb 3, 2003, 09:16 PM

AAA

Andrew did you steal Jason's vodoo doll to make me suffer

.j/k
Anyway PM me about the DPortal.

konjini · Feb 4, 2003, 05:51 PM

Anyone know a progrram with witch I cude upload the database beckup to the server?
Atleast if ther is one?

?

Jeff · Feb 4, 2003, 05:59 PM

phpMyAdmin may do the trick for you.

konjini · Feb 4, 2003, 06:30 PM

phpMyAdmin is server based right, what you exess over your browser?
If so I ain't looking for that becose that ain't working, but more something inline like a FTP.exe proggy.

Jeff · Feb 4, 2003, 07:34 PM

Ahh, I'm of no help then

konjini · Feb 4, 2003, 08:08 PM

Thanks m8 !

Bin in contact with my webhost about this becose ther realy is something rong on ther side

.
Hope to get it figured out soon.

BTW is ther a tool to scan sql for error's or something like that?

Feb 3, 2003, 04:04 PM	#1
konjini DriverHeaven Junior Member Join Date: May 2002 Location: Heerlen (NL) Posts: 85 Rep Power: 0	Need some php help! PLS!!! http://www.clanhgs.com/forum/portal.php?page=1 I've installed the stats mod and now i'm getting that error for the portal page. __________________ iMMortal Clan (WA) Sponsored by: www.extremegameservers.net

Feb 3, 2003, 04:34 PM	#2
UberLord A Legend in Underwear Join Date: May 2002 Location: Unknown Posts: 5,255 Rep Power: 0	Looks like the stats mod has removed a vital table. I suggest rolling the database and forum scripts back to a working backup and reporting the bug with the mod makers. You do keep backups dont you? And doing a full backup before any major changes? __________________ Gentoo Linux - Developer (baselayout) Read my blog "I contend that we are both atheists. I just believe in one fewer god than you do. When you understand why you dismiss all the other possible gods, you will understand why I dismiss yours." Stephen Roberts

Feb 3, 2003, 04:58 PM	Thread Starter #4
konjini DriverHeaven Junior Member Join Date: May 2002 Location: Heerlen (NL) Posts: 85 Rep Power: 0	The NutPortal Stats Mod __________________ iMMortal Clan (WA) Sponsored by: www.extremegameservers.net

Feb 3, 2003, 06:20 PM	#5
UberLord A Legend in Underwear Join Date: May 2002 Location: Unknown Posts: 5,255 Rep Power: 0	Yeah, that SQL code will create the table you need __________________ Gentoo Linux - Developer (baselayout) Read my blog "I contend that we are both atheists. I just believe in one fewer god than you do. When you understand why you dismiss all the other possible gods, you will understand why I dismiss yours." Stephen Roberts

Feb 3, 2003, 08:54 PM	Thread Starter #6
konjini DriverHeaven Junior Member Join Date: May 2002 Location: Heerlen (NL) Posts: 85 Rep Power: 0	Aaaa crap wtf...traying to roll beck the beckup i've made for the sql and it's refusing it. Just fucking great . SQL code is from the portal it self, the original but i'm quasing ther shude be something added about that stats thing in ther. Me feels like killing someone and getting beck to DeluxPortal afther that . __________________ iMMortal Clan (WA) Sponsored by: www.extremegameservers.net

Feb 3, 2003, 09:16 PM	Thread Starter #7
konjini DriverHeaven Junior Member Join Date: May 2002 Location: Heerlen (NL) Posts: 85 Rep Power: 0	AAA Andrew did you steal Jason's vodoo doll to make me suffer .j/k Anyway PM me about the DPortal. __________________ iMMortal Clan (WA) Sponsored by: www.extremegameservers.net

Feb 4, 2003, 05:51 PM	Thread Starter #8
konjini DriverHeaven Junior Member Join Date: May 2002 Location: Heerlen (NL) Posts: 85 Rep Power: 0	Anyone know a progrram with witch I cude upload the database beckup to the server? Atleast if ther is one? ? __________________ iMMortal Clan (WA) Sponsored by: www.extremegameservers.net Last edited by konjini; Feb 4, 2003 at 05:57 PM.

Feb 4, 2003, 05:59 PM	#9
Jeff Yarr... I be blind! Join Date: May 2002 Location: Calgary, Canada Posts: 3,191 Rep Power: 80	phpMyAdmin may do the trick for you. __________________

Feb 4, 2003, 06:30 PM	Thread Starter #10
konjini DriverHeaven Junior Member Join Date: May 2002 Location: Heerlen (NL) Posts: 85 Rep Power: 0	phpMyAdmin is server based right, what you exess over your browser? If so I ain't looking for that becose that ain't working, but more something inline like a FTP.exe proggy. __________________ iMMortal Clan (WA) Sponsored by: www.extremegameservers.net

Feb 4, 2003, 07:34 PM	#11
Jeff Yarr... I be blind! Join Date: May 2002 Location: Calgary, Canada Posts: 3,191 Rep Power: 80	Ahh, I'm of no help then __________________

Feb 4, 2003, 08:08 PM	Thread Starter #12
konjini DriverHeaven Junior Member Join Date: May 2002 Location: Heerlen (NL) Posts: 85 Rep Power: 0	Thanks m8 ! Bin in contact with my webhost about this becose ther realy is something rong on ther side . Hope to get it figured out soon. BTW is ther a tool to scan sql for error's or something like that? __________________ iMMortal Clan (WA) Sponsored by: www.extremegameservers.net Last edited by konjini; Feb 4, 2003 at 08:13 PM.