Previous Thread
Next Thread
Print Thread
Rate Thread
#284284 03/14/2005 5:45 PM
Joined: Nov 2002
Posts: 554
Code Monkey
Code Monkey
Offline
Joined: Nov 2002
Posts: 554
Egad whats this mean?

Control panel message
Script: /usr/www/efs/ubbthreads/ci_builders/newposts.php
Line#: 69
SQL Error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ') ORDER BY t1.B_Posted DESC LIMIT 5' at line 6
SQL Error #: 1064
Query: SELECT t1.B_Number,t1.B_Board,t1.B_Subject,t1.B_Body,t2.U_Username,t1.B_Posted,t1.B_PosterId FROM w3t_Posts AS t1, w3t_Users AS t2 WHERE t1.B_PosterId = t2.U_Number AND B_Board IN () ORDER BY t1.B_Posted DESC LIMIT 5

trying to create a content island in 6.5

Sponsored Links
barbiro #284285 03/14/2005 5:52 PM
Joined: Aug 2000
Posts: 3,590
Moderator
Moderator
Offline
Joined: Aug 2000
Posts: 3,590
did you make sure to select a forum?

Joined: Dec 2000
Posts: 1,471
Addict
Addict
Offline
Joined: Dec 2000
Posts: 1,471
Ian is right, you didn't select a forum. That bug should have been fixed in 6.5.1 if I remember correctly.

-Fusion- #284287 03/14/2005 6:45 PM
Joined: Nov 2002
Posts: 554
Code Monkey
Code Monkey
Offline
Joined: Nov 2002
Posts: 554
They are selected and they show as being created but do not appear in the folder. I think this may be a permissions issue. What are the requirements of the Content Islands folder?

barbiro #284288 03/15/2005 12:13 AM
Joined: Aug 2000
Posts: 3,590
Moderator
Moderator
Offline
Joined: Aug 2000
Posts: 3,590
I don't think it'd be a permissions issue if it's erroring out with the sql.

try rebuilding the output

Sponsored Links
Joined: Nov 2002
Posts: 554
Code Monkey
Code Monkey
Offline
Joined: Nov 2002
Posts: 554
Tried that too-If I look in the folder I dont see the actual files but I see them listed in the control panel.

barbiro #284290 03/15/2005 4:46 PM
Joined: Aug 2000
Posts: 3,590
Moderator
Moderator
Offline
Joined: Aug 2000
Posts: 3,590
does it show you the time of the last update? because on a text forum, it didn't show the time till I rebuilt the content islands, and then the file showed up.

Joined: Nov 2002
Posts: 554
Code Monkey
Code Monkey
Offline
Joined: Nov 2002
Posts: 554
New Recent Visitors Island
Tue Mar 15 2005 01:47 PM Recent Visitors / All Forums HTML-JS
[Show Links]
2 New Posts Island
Mon Mar 14 2005 03:51 PM New Posts
Last 5 / All Forums HTML
[Show Links]
3 New Posts Island
Mon Mar 14 2005 03:42 PM New Posts
Last 5 / All Forums HTML RSS-20
[Show Links]
4 PHPrcon Help
Tue Mar 15 2005 01:42 PM New Posts
Last 5 / 4 Forums RSS-20
[Show Links]
5 PHPrcon Help
Tue Mar 15 2005 01:42 PM New Posts
Last 5 / 4 Forums HTML RSS-20
[Show Links]
6 New Topics Island
Tue Mar 15 2005 01:42 PM New Topics
Last 5 / 4 Forums HTML-JS


Apparently its doing something. Sorry for my lack of knowledge but I have none in this particular area. Is there a place to delete any of these?


and Rebuild Output

Control panel message
Script: /usr/www/efs/ubbthreads/ci_builders/newposts.php
Line#: 69
SQL Error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ') ORDER BY t1.B_Posted DESC LIMIT 5' at line 6
SQL Error #: 1064
Query: SELECT t1.B_Number,t1.B_Board,t1.B_Subject,t1.B_Body,t2.U_Username,t1.B_Posted,t1.B_PosterId FROM w3t_Posts AS t1, w3t_Users AS t2 WHERE t1.B_PosterId = t2.U_Number AND B_Board IN () ORDER BY t1.B_Posted DESC LIMIT 5

Last edited by ChAoS; 03/15/2005 4:52 PM.
barbiro #284292 03/15/2005 5:29 PM
Joined: Aug 2000
Posts: 3,590
Moderator
Moderator
Offline
Joined: Aug 2000
Posts: 3,590
do a query that pulls all of the information out of the content islands table. see if it contains the info for which forums you want to use. if it's supposed to, but is blank, try running an UPDATE to add in the info

Joined: Nov 2002
Posts: 554
Code Monkey
Code Monkey
Offline
Joined: Nov 2002
Posts: 554
Well Im not to proud to admin something when I don't know it.

What would the query be?

Sponsored Links
barbiro #284294 03/19/2005 2:33 PM
Joined: Nov 2002
Posts: 554
Code Monkey
Code Monkey
Offline
Joined: Nov 2002
Posts: 554
maybe this gives some info?

13:51:50 -0800
ChAoS Script: /usr/www/efs/ubbthreads/ci_builders/newposts.php - Line: 69
SELECT t1.B_Number,t1.B_Board,t1.B_Subject,t1.B_Body,t2.U_Username,t1.B_Posted,t1.B_PosterId
FROM w3t_Posts AS t1,
w3t_Users AS t2
WHERE t1.B_PosterId = t2.U_Number

AND B_Board IN ()
ORDER BY t1.B_Posted DESC
LIMIT 5
- You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ')
ORDER BY t1.B_Posted DESC
LIMIT 5' at line 6

barbiro #284295 03/19/2005 3:19 PM
Joined: Aug 2000
Posts: 3,590
Moderator
Moderator
Offline
Joined: Aug 2000
Posts: 3,590
you'll need to do something like

SELECT * FROM w3t_ContentIslands

Post anything returned

Joined: Nov 2002
Posts: 554
Code Monkey
Code Monkey
Offline
Joined: Nov 2002
Posts: 554
1 New Recent Visitors Island visitors 1111270392 N; 0 0 1 0 100% 0 0 0 15 xml 50
2 New Posts Island newposts 1110923510 a:1:{i:0;s:8:"category";} 5 0 0 1 100% 0 0 0 efa05b6ee7175353582b37eed7b72e8b 15 xml 0
3 New Posts Island newposts 1110843735 a:5:{i:0;s:8:"category";i:1;s:8:"category";i:2;s:8:"category";i:3;s:8:"category";i:4;s:8:"category";} 5 0 0 1 100% 0 0 1 b0d7293fd4d10e9fc2d6066cea3bbd8b 15 xml 0
4 PHPrcon Help newposts 1111270831 a:4:{i:0;s:12:"phprcgeneral";i:1;s:8:"phprcbug";i:2;s:12:"phprcinstall";i:3;s:6:"phptpl";} 5 200 0 0 100% 0 0 1 15 xml 0
5 PHPrcon Help newposts 1111270831 a:4:{i:0;s:12:"phprcgeneral";i:1;s:8:"phprcbug";i:2;s:12:"phprcinstall";i:3;s:6:"phptpl";} 5 200 0 1 100% 0 0 1 15 xml 0
6 New Topics Island newtopics 1111270831 a:4:{i:0;s:12:"phprcgeneral";i:1;s:8:"phprcbug";i:2;s:12:"phprcinstall";i:3;s:6:"phptpl";} 5


Thankyou Ian

barbiro #284297 03/19/2005 9:20 PM
Joined: Aug 2000
Posts: 3,590
Moderator
Moderator
Offline
Joined: Aug 2000
Posts: 3,590
I've got no idea. The serialized code is just arrays of the word "category"

Try editing the content island, and see how that information changes


Link Copied to Clipboard
Donate Today!
Donate via PayPal

Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.

Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.
Recommended Hosts
We have personally worked with and recommend the following Web Hosts:
Stable Host
bluehost
InterServer
Visit us on Facebook
Member Spotlight
Posts: 70
Joined: January 2007
Forum Statistics
Forums63
Topics37,573
Posts293,925
Members13,849
Most Online5,166
Sep 15th, 2019
Today's Statistics
Currently Online
Topics Created
Posts Made
Users Online
Birthdays
Top Posters
AllenAyres 21,079
JoshPet 10,369
LK 7,394
Lord Dexter 6,708
Gizmo 5,833
Greg Hard 4,625
Top Posters(30 Days)
Top Likes Received
isaac 82
Gizmo 20
Brett 7
Morgan 2
Top Likes Received (30 Days)
None yet
The UBB.Developers Network (UBB.Dev/Threads.Dev) is ©2000-2024 VNC Web Services

 
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20221218)