Clan Themes, We Make Clans Look Good!

CT on Facebook

Latest Product

Mech Warrior Online Xtreme Theme

User Box

Anonymous

38.107.179.219

PND Downloads Feed

How to Delete or Reset yo...

Lost your admin password ?Â Cant login to your admin account ? This s...

Back Online & Stuff

Look at us with our nifty website back up and running… Seriously...

How to edit the admins in...

Here is a way to make someone admin in your forums on your Evo site. I...

Demo Splash Screen

Ped @ Clan Themes has released a simple splash screen entrance hack.Â ...

Free Phpnuke Business The...

This is the 6th Business theme for Phpnuke that Clan Themes has releas...

Tricked Out Slider

We have seen some great new things come out of Tricked Out News and th...

Phpnuke Downloads

Custom Work

www.clanthemes.com :: View topic - NEED HELP ASAP

NEED HELP ASAP

6 Replies / 1367 Views


www.clanthemes.com Forum Index » General PhpNuke	View previous topic :: View next topic

cupoftea
Reputation: 21.7
Local time: 4:17 PM
Location: Behind My Computer

Spammer

0.08 posts per day
Medals: 0

Joined: Apr 30, 2008
Last Visit: 14 Mar 2009
Posts: 113
Points: 2379

NEED HELP ASAP Posted: Mon Dec 08, 2008 7:28 pm

Srry for the title, but i rlly need help ASAP...

I have a problem with my database... It is empty, and my latest backup doesn't work!
It always gives an error at the places where the query goes:

Code:

TYPE=;

An exemple here:

Code:

-- Advanced Nuke Backup MySQL dump 1.1
--
-- ------------------------------------------------------
-- Server Version 4.1.18-log

--
-- Table structure for table `nuke_antiflood`
--

DROP TABLE IF EXISTS `nuke_antiflood`;
CREATE TABLE `nuke_antiflood` (
`ip_addr` varchar(48) NOT NULL default '',
`time` varchar(14) NOT NULL default '',
KEY `ip_addr` (`ip_addr`),
KEY `time` (`time`)
) TYPE=;

--
-- Table structure for table `nuke_authors`
--

DROP TABLE IF EXISTS `nuke_authors`;
CREATE TABLE `nuke_authors` (
`aid` varchar(25) NOT NULL default '',
`name` varchar(50) NULL,
`url` varchar(255) NOT NULL default '',
`email` varchar(255) NOT NULL default '',
`pwd` varchar(40) NULL,
`counter` int(11) NOT NULL default '0',
`radminsuper` tinyint(1) NOT NULL default '1',
`admlanguage` varchar(30) NOT NULL default '',
PRIMARY KEY (`aid`),
KEY `aid` (`aid`)
) TYPE=;

...

Grtz, CupOfTea --- My Nuke Version: 8.0 Patched 3.5 ---

DreAdeDcoRpSE
Reputation: 2572.3
votes: 28
Local time: 10:17 AM
Location: Back of your Mind

Site Admin

1.36 posts per day
Medals: 3 (View more...)

Forums Moderator

Joined: Sep 22, 2007
Last Visit: 24 May 2012
Posts: 2331
Points: 136106

Re: NEED HELP ASAP Posted: Mon Dec 08, 2008 8:04 pm
Shop Purchases:Enemy Territory Theme (Aviator) for PHP Nuke · Clan Roster 2.0 · · Modern Warfare 3 Xtreme Theme

Have you tried contacting your host and see if they have a backup. Most companies make a backup on there end once every 24 hours or once a week. If they did, then they should be able to revert back to that time. But you would loose everything from when they backed it up and now.

Noto
Reputation: 1072.7
votes: 13
Local time: 4:17 PM
Location: Sunny UK !

Site Admin

0.60 posts per day
Medals: 3 (View more...)

Theme Guru

Joined: May 03, 2007
Last Visit: 25 May 2012
Posts: 1118
Points: 73943

NEED HELP ASAP Posted: Mon Dec 08, 2008 11:57 pm

Wish my host done that Crying

DreAdeDcoRpSE
Reputation: 2572.3
votes: 28
Local time: 10:17 AM
Location: Back of your Mind

Site Admin

1.36 posts per day
Medals: 3 (View more...)

Forums Moderator

Joined: Sep 22, 2007
Last Visit: 24 May 2012
Posts: 2331
Points: 136106

Re: NEED HELP ASAP Posted: Tue Dec 09, 2008 2:57 am
Shop Purchases:Enemy Territory Theme (Aviator) for PHP Nuke · Clan Roster 2.0 · · Modern Warfare 3 Xtreme Theme

Noto wrote:

Wish my host done that Crying

My last 3 companies I went through and my current company I go through do it. I am not sure how often though.

cupoftea
Reputation: 21.7
Local time: 4:17 PM
Location: Behind My Computer

Spammer

0.08 posts per day
Medals: 0

Joined: Apr 30, 2008
Last Visit: 14 Mar 2009
Posts: 113
Points: 2379

SOLVED: NEED HELP ASAP Posted: Tue Dec 09, 2008 2:41 pm

Since my host is free, they don't provide any service at all, accept hosting my files. Because I'm only developing my site, I don't really care, I will get a paid host when the site is ready though.

You guys really have no idea how to fix the query?

---SOLVED---

I replaced all

Code:

TYPE=;

By nothing and then I got the next error:

Code:

TYPE= AUTO_INCREMENT=X;
(replace X with a number)

and I removed all of them too, and then it worked!!!

Thx for the help anyway!

Last edited by cupoftea on Tue Dec 09, 2008 3:07 pm; edited 1 time in total

Untergang
Reputation: 642.5
votes: 6
Local time: 4:17 PM
Location: Lommel

Stand-by Stand-by

0.19 posts per day
Medals: 0

Joined: May 08, 2007
Last Visit: 31 Oct 2011
Posts: 346
Points: 22131

Re: NEED HELP ASAP Posted: Tue Dec 09, 2008 2:54 pm

Just remove TYPE= from each instruction.
It doesn't need that to be albe to work.

UDesigns.be

cupoftea
Reputation: 21.7
Local time: 4:17 PM
Location: Behind My Computer

Spammer

0.08 posts per day
Medals: 0

Joined: Apr 30, 2008
Last Visit: 14 Mar 2009
Posts: 113
Points: 2379

NEED HELP ASAP Posted: Tue Dec 09, 2008 3:08 pm

Thx Untergang,

you posted this exactly at the moment i tried to do this...
lol

Grtz

www.clanthemes.com Forum Index » General PhpNuke

6 Replies / 1367 Views
Page 1 of 1
All times are GMT

Display posts from previous:

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You can download files in this forum

Company Information
Home · About Us · Affiliates · Advertising
Link To Us · Newsletter · Contact Us · Site Map
All content © Clan Themes 2006 - 2012
Based on RavenNuke

Clan Themes, We Make Clans Look Good!

Sponsors

CT on Facebook

Latest Product

User Box

PND Downloads Feed

Custom Work