UBB.Developers Forums UBB.threads 7 Development How Do I? Content Islands

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

did you make sure to select a forum?

Ian is right, you didn't select a forum. That bug should have been fixed in 6.5.1 if I remember correctly.

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?

I don't think it'd be a permissions issue if it's erroring out with the sql.

try rebuilding the output

Tried that too-If I look in the folder I dont see the actual files but I see them listed in the control panel.

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.

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

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

Well Im not to proud to admin something when I don't know it.

What would the query be?

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

you'll need to do something like

SELECT * FROM w3t_ContentIslands

Post anything returned

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

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