1
bikingman82
Re: CBB error
  • 2008/6/1 21:41

  • bikingman82

  • Just popping in

  • Posts: 8

  • Since: 2008/5/13


I will give that a try.



2
bikingman82
CBB error
  • 2008/6/1 11:41

  • bikingman82

  • Just popping in

  • Posts: 8

  • Since: 2008/5/13


I am getting this error in my CBB forums. Everything looks fine and I can see the main page, but when I click on a forum section I get this error:

An Error Occured
SELECT t.*, u.name, u.uname, u2.uid, u2.name as last_post_name, u2.uname as last_poster,
p.post_time as last_post_time, p.poster_name as last_poster_name, p.icon, p.post_id, p.post_karma,
p.require_reply, pt.post_text FROM xoops_bb_topics t LEFT JOIN xoops_users u ON u.uid = t.topic_poster
LEFT JOIN xoops_bb_posts p ON p.post_id = t.topic_last_post_id LEFT JOIN xoops_bb_posts_text pt ON
pt.post_id = t.topic_last_post_id LEFT JOIN xoops_users u2 ON u2.uid = p.uid WHERE (p.post_time > 1203678864 OR t.topic_sticky=1)
AND t.forum_id = 13 AND t.approved = 1 AND p.approved = 1 ORDER BY t.topic_sticky DESC, p.post_time DESC
If the page does not automatically reload, please click here


And then it kicks me back to the main page. Could anyone help tell me what is going wrong here.

Thanks



3
bikingman82
Re: Installing Protector
  • 2008/5/29 19:00

  • bikingman82

  • Just popping in

  • Posts: 8

  • Since: 2008/5/13


I'm not blaming Protector for anything. I am just trying to figure out why it is having this issue. The server I use is supplied by brinkster.com. The server is a Windows 2003 IIS 6.



4
bikingman82
Re: Installing Protector
  • 2008/5/29 15:40

  • bikingman82

  • Just popping in

  • Posts: 8

  • Since: 2008/5/13


Hi I Installed protector on my XOOPS site and I am getting this error 2 or 3 times a day for several minutes and then the site is fine for awhile then the error will appear again. Can anyone help me out?


Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in C:\Sites\Single17\xxxxx\webroot\htdocs\modules\protector\include\precheck.inc.php on line 26

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in C:\Sites\Single17\xxxxx\webroot\htdocs\modules\protector\class\protector.php on line 44

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\Sites\Single17\xxxxx\webroot\htdocs\modules\protector\class\protector.php on line 45

Notice: Undefined index: passwd_disabling_bip in C:\Sites\Single17\xxxxx\webroot\htdocs\modules\protector\include\precheck.inc.php on line 35

Notice: Undefined index: passwd_disabling_bip in C:\Sites\Single17\xxxxx\webroot\htdocs\modules\protector\include\precheck.inc.php on line 36

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in C:\Sites\Single17\xxxxx\webroot\htdocs\modules\protector\include\precheck.inc.php on line 37

Notice: Undefined index: reliable_ips in C:\Sites\Single17\xxxxx\webroot\htdocs\modules\protector\include\precheck.inc.php on line 44

Warning: Invalid argument supplied for foreach() in C:\Sites\Single17\xxxxx\webroot\htdocs\modules\protector\include\precheck.inc.php on line 46
This page cannot be displayed due to an internal error.

You can provide the following information to the administrators of this site to help them solve the problem:

Error: Unable to connect to database



5
bikingman82
Re: Table borders
  • 2008/5/23 0:13

  • bikingman82

  • Just popping in

  • Posts: 8

  • Since: 2008/5/13


That worked perfect... Thanks so much!



6
bikingman82
Table borders
  • 2008/5/22 22:08

  • bikingman82

  • Just popping in

  • Posts: 8

  • Since: 2008/5/13


Ok I know this is probably an easy answer and I am just not looking in the right place. But I am trying to add borders around the tables of my forum. Currently I love the way my theme works for the whole site, but when it comes to the forum section where I am using CBB it looks like all the info runs together. So what would I need to add to make these tables have a border and on which file would I need to look for it? the .CSS file or the theme.html file?

Resized Image

Same area selected, so I know there are tables in there.
Resized Image

Thanks in advance for any help you can give me.



7
bikingman82
Re: Could not connect to the database serve
  • 2008/5/13 20:04

  • bikingman82

  • Just popping in

  • Posts: 8

  • Since: 2008/5/13


ok I found the fix if you are getting this error.

I had to go and enable MySQL in the php.ini file.

navigate to the php.ini.default file by typing cd /etc.

In its current state, php.ini.default does nothing; php launches with its default values. In order for php to read the ini file, it must be renamed to php.ini. We will do a copy to retain the default file, just in case:

sudo cp php.ini.default php.ini

sudo pico php.ini. Press Control-W and search for mysql.default_socket, and make it look like this:
mysql.default_socket = /tmp/mysql.sock
Save the changes by pressing hen pressing Control-X, then press Y, then press Enter.

Doing this fixed the issue.



8
bikingman82
Re: Could not connect to the database serve
  • 2008/5/13 18:12

  • bikingman82

  • Just popping in

  • Posts: 8

  • Since: 2008/5/13


I have this exact same problem. I also am on a mac using MySQL 5.0.51b. I have the permission set for the database and flushed but I still get a red light at Check Database. Saying could not connect to the database server.




TopTop



Login

Who's Online

225 user(s) are online (151 user(s) are browsing Support Forums)


Members: 0


Guests: 225


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Apr 30
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits