| Author |
Message |
Raven
Site Admin/Owner
Joined: Aug 27, 2002
Posts: 16987
Location: Kansas
|
 Posted:
Sat Dec 22, 2007 12:12 pm |
 
|
I didn't look at the schema so it could be that the extra 2 columns can't be empty ( '','' ). Like I said, I didn't have your phpMyAdmin url, id, pass so I just took a guess. Look at the schema and if it says NOT NULL for either of the columns then in place of the '' use a legal value. |
|
|
   
|
|
sowsteady
Regular
Joined: Apr 09, 2004
Posts: 87
Location: UK
|
| Posted:
Sat Dec 22, 2007 1:23 pm |
|
Hi Raven,
I don't understand what you mean so I sent you another PM to see if that will help you access the database.
Thanks. |
|
|
|
|
|
Raven
Site Admin/Owner
Joined: Aug 27, 2002
Posts: 16987
Location: Kansas
|
| Posted:
Sat Dec 22, 2007 1:48 pm |
|
I'll look into it later if/when I have a chance.
 |
|
|
|
|
|
sowsteady
Regular
Joined: Apr 09, 2004
Posts: 87
Location: UK
|
| Posted:
Sat Dec 22, 2007 2:19 pm |
|
OK, many thanks Raven. I'm definitely stumped. |
|
|
|
|
|
Raven
Site Admin/Owner
Joined: Aug 27, 2002
Posts: 16987
Location: Kansas
|
| Posted:
Tue Dec 25, 2007 12:50 am |
|
Fixed! 
Cause: The original schema had been modified with 2 additional columns added to the end.
Fix: Modified the INSERT statement to add DEFAULT values for the 2 missing columns.
Merry Christmas!!
|
|
|
|
|
|
sowsteady
Regular
Joined: Apr 09, 2004
Posts: 87
Location: UK
|
| Posted:
Tue Dec 25, 2007 3:43 am |
|
| Raven wrote: | Fixed!
Cause: The original schema had been modified with 2 additional columns added to the end.
Fix: Modified the INSERT statement to add DEFAULT values for the 2 missing columns.
Merry Christmas!!
|
Raven -> 
Small donation from Father "SlowSteady Christmas on the way!  |
|
|
|
|
|
Raven
Site Admin/Owner
Joined: Aug 27, 2002
Posts: 16987
Location: Kansas
|
| Posted:
Tue Dec 25, 2007 4:50 am |
|
|
|
|
|
|
|
|
|
![[Valid RSS]](http://www.ravenphpscripts.com/images/valid-rss.png "Validate my RSS feed"){kind=small}
:: 
::
