https://www.icyphoenix.com/viewtopic.php?f=35&t=2749
-----------------------------------
dxlwebs
Thu 06 Sep, 2007 14:47

Database Error
-----------------------------------
hello i am trying to get my downloads to work i went into the admin area and deleted the test catagory and went to put my new catagories in and this poped up 
Couldn't add a new category

DEBUG MODE

SQL Error : 1364 Field 'parents_data' doesn't have a default value

INSERT INTO ip_pa_cat (cat_name, cat_desc, cat_parent, cat_order, cat_allow_file, cat_allow_ratings, cat_allow_comments) VALUES('test', 'test', 0, 10, 0, 0, 0)

Line : 1212
File : functions_pafiledb.php

i have tried everything in the db maintenance section but nothing changes what do i do please help me please


-----------------------------------
dxlwebs
Sat 08 Sep, 2007 13:18

Re: Database Error
-----------------------------------
Can no one help me at all ? Mighty Gorgon can you not help me please i need to get this option working


-----------------------------------
z3d0
Sat 08 Sep, 2007 19:01

Re: Database Error
-----------------------------------
i've just tried with v. 1.1.0.15b and I don't get this error


-----------------------------------
dxlwebs
Sun 09 Sep, 2007 23:50

Re: Database Error
-----------------------------------
I checked out the database and ip_pa_cat is there it have 1kb in it lol so why is my website telling me its not there does anyone know ?


-----------------------------------
novice programmer
Mon 10 Sep, 2007 20:29

Re: Database Error
-----------------------------------
[quote user="dxlwebs" post="19511"]I checked out the database and ip_pa_cat is there it have 1kb in it lol so why is my website telling me its not there does anyone know ?[/quote]

That´s strange... My board haven´t got any post or user but me and it has got about 700Kb of size.
Try to back-up your db.


-----------------------------------
dxlwebs
Mon 10 Sep, 2007 20:32

Re: Database Error
-----------------------------------
already done that and i have even tried to restore it but nothing! i mean how can this be!


-----------------------------------
novice programmer
Mon 10 Sep, 2007 20:49

Re: Database Error
-----------------------------------
[quote user="dxlwebs" post="19521"]already done that and i have even tried to restore it but nothing! i mean how can this be![/quote]
Is a live site (I mean, somebody not from your computer can acess)?
Are the sql settings on config.php well?
Has your server changed form mysql3x to mysql4x/5x?

If the answers are:

[code linenumbers=false]
1.-Yes
2.-Yes
3.-No
[/code]

Then there could be SECURITY ISSUE!

Please post the answers asaw.
[b][u][i]If your answers match with mine´s, inform of a possible SECURITY ISSUE[/i][/u][/b]


-----------------------------------
dxlwebs
Mon 10 Sep, 2007 20:55

Re: Database Error
-----------------------------------
the site is live yes but what happened was i uploaded the site and installed everything and in downloads it has the test category right so i went into ACP and deleted that category and ass i did that my server which has always been mysql4x had been crashing but not at that time it was fine then but when i tried to put a new category in there it came up with that problem!

so i have no idea whats going on!

i do have the config file up i think but my site is brand new no one knows about it yet not realy!


-----------------------------------
dxlwebs
Mon 10 Sep, 2007 21:00

Re: Database Error
-----------------------------------
what is really strange is the fact that the website works fine and the download page its self says your dont have the correct access or there is no categories which there isnt because of that problem the only other thing that doesnt work is the cradits page which said the page is too long or something like that!


-----------------------------------
novice programmer
Mon 10 Sep, 2007 21:03

Re: Database Error
-----------------------------------
[quote user="dxlwebs" post="19527"]the site is live yes but what happened was i uploaded the site and installed everything and in downloads it has the test category right so i went into ACP and deleted that category and ass i did that my server which has always been mysql4x had been crashing but not at that time it was fine then but when i tried to put a new category in there it came up with that problem!

so i have no idea whats going on!

i do have the config file up i think but my site is brand new no one knows about it yet not realy![/quote]

But if you have got the sql server down, then it will come up a critical error messege.


-----------------------------------
dxlwebs
Mon 10 Sep, 2007 21:05

Re: Database Error
-----------------------------------
no it was going down every now and then but that problem is fixed and if the server was down the whole site would not work at all because it needs the server to run


-----------------------------------
novice programmer
Thu 13 Sep, 2007 23:58

Re: Database Error
-----------------------------------
tried to optimize the db?
tried to repair the db?


-----------------------------------
Mighty Gorgon
Mon 17 Sep, 2007 01:45

Re: Database Error
-----------------------------------
I still don't understand where the problem is in this topic... :roll:


