Author |
Topic |
|
Carefree
Advanced Member
Philippines
4207 Posts |
Posted - 20 May 2016 : 07:26:31
|
Here's an excerpt from "post_info.asp":
Now, here's the result:
There has been a problem!
INSERT INTO FORUM_FORUM (CAT_ID, F_PARENT, F_STATUS, F_PRIVATEFORUMS, F_LAST_POST, F_LAST_POST_AUTHOR, F_SUBJECT, F_URL, F_DESCRIPTION, F_TYPE, F_L_ARCHIVE, F_ARCHIVE_SCHED, F_L_DELETE, F_DELETE_SCHED, F_SUBSCRIPTION, F_MODERATION, F_ORDER, F_DEFAULTDAYS) VALUES (3, , 1, 0, '20160520170043', 1, 'Snitz Forums', 'http://forum.snitz.com/forum', 'Snitz Forums 2000', 1, '', 30, '', 365, 0, 0, 1, 30) There was an error = Syntax error in INSERT INTO statement.
Go back to correct the problem.
I've looked at this until I went cross-eyed. Can't see the issue. |
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 20 May 2016 : 08:06:58
|
My gues is this bit here INSERT INTO FORUM_FORUM (CAT_ID, F_PARENT, F_STATUS, F_PRIVATEFORUMS, F_LAST_POST .... VALUES (3,There should be either a value or NULL here , 1, 0, '20160520170043'
As you can see, there is no value for F_PARENT in the corresponding VALUES section |
|
|
Carefree
Advanced Member
Philippines
4207 Posts |
Posted - 20 May 2016 : 09:46:55
|
Found it. It was actually caused by another section of code, a method_type comparison didn't include URLs. |
|
|
|
Topic |
|
|
|