|
Joined: Jul 2007
Posts: 70
journeyman
|
journeyman
Joined: Jul 2007
Posts: 70 |
I am sorry if this has already been talked about however I can't find the help I need. I am running 7.5.3 And have started getting people complaining about this message UBB Message We encountered a problem. The reason reported was Database error only visible to forum administrators
Please click back to return to the previous page. I also need to keep logging in each time I come back to the message board??
Best Regards Danny de Hek - Below is our Office Cam Image
|
|
|
|
Joined: Dec 2003
Posts: 6,562 Likes: 78
|
Joined: Dec 2003
Posts: 6,562 Likes: 78 |
Okay the first thing is this is a generic message that does not tell you anything about the actual problem. So you have two options to find the error. One is to enable error logs in the control panel. Control Panel ยป Primary Settings-Logging Then login to the control panel and view the error logs Or enable the display to all users in mysql.inc.php Here is one post that references how to do it. If you opt to edit the file it is strongly suggested to go back and turn it off since it displays info to anyone that logs onto the site not just the admin.
Blue Man Group There is no such thing as stupid questions. Just stupid answers
|
|
|
|
Joined: Dec 2003
Posts: 6,562 Likes: 78
|
Joined: Dec 2003
Posts: 6,562 Likes: 78 |
It looks like your site is a on/off problem so it may be the forum software has issues accessing the database server. But once you enable error logs or edit the mysql.inc.php file. You really won't know.
Blue Man Group There is no such thing as stupid questions. Just stupid answers
|
|
|
|
Joined: Jul 2007
Posts: 70
journeyman
|
journeyman
Joined: Jul 2007
Posts: 70 |
I have already got log files heaps of them, not sure if this is the problem with try the other stuff as well [ERROR][Mon, Jul 06 2009 00:02:00 +1200] [] [] Script: /usr/wwwroot/ddehek/newzealandnz/message-board/libs/html.inc.php - Line: 414 insert into ubbt_REFERER_LOG (REFERER_DATE,REFERER_URL) values ( 1246795320 , 'http://www.google.com.ph/search?q=DIFFERENT+KINDS+OF+HOWLING+DOGS&ie=utf-8&oe=utf-8&aq=t&rls=org.mozilla:en-US:official&client=firefox-a' ) - Can't open file: 'ubbt_REFERER_LOG.MYI' (errno: 145) [ERROR][Mon, Jul 06 2009 00:22:42 +1200] [] [] Script: /usr/wwwroot/ddehek/newzealandnz/message-board/libs/html.inc.php - Line: 414 insert into ubbt_REFERER_LOG (REFERER_DATE,REFERER_URL) values ( 1246796562 , 'http://www.google.com/search?q=does+new+zealand+have+bears%3F&ie=utf-8&oe=utf-8&aq=t&rls=org.mozilla:en-US:official&client=firefox-a' ) - Can't open file: 'ubbt_REFERER_LOG.MYI' (errno: 145) [ERROR][Mon, Jul 06 2009 00:34:27 +1200] [] [] Script: /usr/wwwroot/ddehek/newzealandnz/message-board/libs/html.inc.php - Line: 414 insert into ubbt_REFERER_LOG (REFERER_DATE,REFERER_URL) values ( 1246797267 , 'http://www.google.com/search?sourceid=navclient&ie=UTF-8&rlz=1T4ADBF_enIQ332IQ333&q=http%3a%2f%2fhelpdesk.awd-network.com%2fadmin.php+' ) - Can't open file: 'ubbt_REFERER_LOG.MYI' (errno: 145) [ERROR][Mon, Jul 06 2009 00:53:07 +1200] [] [] Script: /usr/wwwroot/ddehek/newzealandnz/message-board/libs/html.inc.php - Line: 414 insert into ubbt_REFERER_LOG (REFERER_DATE,REFERER_URL) values ( 1246798387 , 'http://www.google.co.nz/search?hl=en&q=New+shortage+list+in+NZ&meta=cr%3DcountryNZ&aq=f&oq=&rlz=1R2GGLL_en' ) - Can't open file: 'ubbt_REFERER_LOG.MYI' (errno: 145) [ERROR][Mon, Jul 06 2009 00:58:15 +1200] [] [] Script: /usr/wwwroot/ddehek/newzealandnz/message-board/libs/html.inc.php - Line: 414 insert into ubbt_REFERER_LOG (REFERER_DATE,REFERER_URL) values ( 1246798695 , 'http://twur.li' ) - Can't open file: 'ubbt_REFERER_LOG.MYI' (errno: 145) [ERROR][Mon, Jul 06 2009 00:59:23 +1200] [] [] Script: /usr/wwwroot/ddehek/newzealandnz/message-board/libs/html.inc.php - Line: 414 insert into ubbt_REFERER_LOG (REFERER_DATE,REFERER_URL) values ( 1246798763 , 'http://www.nznz.co.nz/' ) - Can't open file: 'ubbt_REFERER_LOG.MYI' (errno: 145) [ERROR][Mon, Jul 06 2009 01:07:23 +1200] [] [] Script: /usr/wwwroot/ddehek/newzealandnz/message-board/libs/html.inc.php - Line: 414 insert into ubbt_REFERER_LOG (REFERER_DATE,REFERER_URL) values ( 1246799243 , 'http://nz-immigration.co.nz/' ) - Can't open file: 'ubbt_REFERER_LOG.MYI' (errno: 145) [ERROR][Mon, Jul 06 2009 01:08:48 +1200] [] [] Script: /usr/wwwroot/ddehek/newzealandnz/message-board/libs/html.inc.php - Line: 414 insert into ubbt_REFERER_LOG (REFERER_DATE,REFERER_URL) values ( 1246799328 , 'http://www.google.co.nz/search?hl=en&q=section+12+immigration+advisors+act&meta=&aq=f&oq=' ) - Can't open file: 'ubbt_REFERER_LOG.MYI' (errno: 145) [ERROR][Mon, Jul 06 2009 01:30:26 +1200] [] [] Script: /usr/wwwroot/ddehek/newzealandnz/message-board/libs/html.inc.php - Line: 414 insert into ubbt_REFERER_LOG (REFERER_DATE,REFERER_URL) values ( 1246800626 , 'http://www.google.com.au/search?hl=en&q=christchurch+franz+%27josef&btnG=Search&meta=' ) - Can't open file: 'ubbt_REFERER_LOG.MYI' (errno: 145) [ERROR][Mon, Jul 06 2009 02:17:45 +1200] [] [] Script: /usr/wwwroot/ddehek/newzealandnz/message-board/libs/html.inc.php - Line: 414 insert into ubbt_REFERER_LOG (REFERER_DATE,REFERER_URL) values ( 1246803465 , 'http://www.google.com.au/search?client=firefox-a&rls=org.mozilla%3Aen-GB%3Aofficial&channel=s&hl=en&q=list+of++Recognised+basic+New+Zealand+qualification&meta=&btnG=Google+Search' ) - Can't open file: 'ubbt_REFERER_LOG.MYI' (errno: 145) [ERROR][Mon, Jul 06 2009 02:23:20 +1200] [] [] Script: /usr/wwwroot/ddehek/newzealandnz/message-board/libs/html.inc.php - Line: 414 insert into ubbt_REFERER_LOG (REFERER_DATE,REFERER_URL) values ( 1246803800 , 'http://uk.search.yahoo.com/search?ei=utf-8&fr=slv8-bt&p=whale%20watching%20ion%20new%20zealand' ) - Can't open file: 'ubbt_REFERER_LOG.MYI' (errno: 145) [ERROR][Mon, Jul 06 2009 02:33:52 +1200] [] [] Script: /usr/wwwroot/ddehek/newzealandnz/message-board/libs/html.inc.php - Line: 414 insert into ubbt_REFERER_LOG (REFERER_DATE,REFERER_URL) values ( 1246804432 , 'http://www.google.de/search?hl=de&q=baby+tyler&btnG=Google-Suche&meta=&aq=f&oq=' ) - Can't open file: 'ubbt_REFERER_LOG.MYI' (errno: 145) [ERROR][Mon, Jul 06 2009 02:40:05 +1200] [] [] Script: /usr/wwwroot/ddehek/newzealandnz/message-board/libs/html.inc.php - Line: 414 insert into ubbt_REFERER_LOG (REFERER_DATE,REFERER_URL) values ( 1246804805 , 'http://www.google.com/search?q=rent+a+car+new+zealand&rls=com.microsoft:*:IE-SearchBox&ie=UTF-8&oe=UTF-8&sourceid=ie7&rlz=1I7SKPB' ) - Can't open file: 'ubbt_REFERER_LOG.MYI' (errno: 145) [ERROR][Mon, Jul 06 2009 02:42:30 +1200] [] [] Script: /usr/wwwroot/ddehek/newzealandnz/message-board/libs/html.inc.php - Line: 414 insert into ubbt_REFERER_LOG (REFERER_DATE,REFERER_URL) values ( 1246804950 , 'http://www.google.com.my/search?hl=en&q=distance+Queenstown+to+Franz+joseph&btnG=Search&meta=' ) - Can't open file: 'ubbt_REFERER_LOG.MYI' (errno: 145) [ERROR][Mon, Jul 06 2009 02:47:22 +1200] [] [] Script: /usr/wwwroot/ddehek/newzealandnz/message-board/libs/html.inc.php - Line: 414 insert into ubbt_REFERER_LOG (REFERER_DATE,REFERER_URL) values ( 1246805242 , 'http://www.franzjosefmotels.co.nz/rate-chart.html' ) - Can't open file: 'ubbt_REFERER_LOG.MYI' (errno: 145) [ERROR][Mon, Jul 06 2009 03:25:22 +1200] [] [] Script: /usr/wwwroot/ddehek/newzealandnz/message-board/libs/html.inc.php - Line: 414 insert into ubbt_REFERER_LOG (REFERER_DATE,REFERER_URL) values ( 1246807522 , 'http://www.google.com.au/search?sourceid=navclient&ie=UTF-8&rlz=1T4SKPB_enAU302AU307&q=christchurch+to+franz+josef' ) - Can't open file: 'ubbt_REFERER_LOG.MYI' (errno: 145) [ERROR][Mon, Jul 06 2009 04:51:18 +1200] [] [] Script: /usr/wwwroot/ddehek/newzealandnz/message-board/libs/html.inc.php - Line: 414 insert into ubbt_REFERER_LOG (REFERER_DATE,REFERER_URL) values ( 1246812678 , 'http://www.google.com.ph/search?hl=en&client=firefox-a&rls=org.mozilla%3Aen-US%3Aofficial&q=OTHER+KIND+OF+HOWLING+DOGS&btnG=Search&meta=' ) - Can't open file: 'ubbt_REFERER_LOG.MYI' (errno: 145) [ERROR][Mon, Jul 06 2009 05:24:30 +1200] [] [] Script: /usr/wwwroot/ddehek/newzealandnz/message-board/libs/html.inc.php - Line: 414 insert into ubbt_REFERER_LOG (REFERER_DATE,REFERER_URL)
Best Regards Danny de Hek - Below is our Office Cam Image
|
|
|
|
Joined: Jun 2006
Posts: 16,299 Likes: 116
|
Joined: Jun 2006
Posts: 16,299 Likes: 116 |
Can't open file: 'ubbt_REFERER_LOG.MYI' (errno: 145) Seems your SQL server has gone awry... I believe the error number 145 means the table is corrupt; so you should run repair on your tables to fix the issue.
|
|
|
|
Joined: Jul 2007
Posts: 70
journeyman
|
journeyman
Joined: Jul 2007
Posts: 70 |
NOTE my Time Format: is set to d/m/y | h:i A as we are in New Zealand maybe this is making the REFERER_DATE,REFERER_URL make a error?
Best Regards Danny de Hek - Below is our Office Cam Image
|
|
|
|
Joined: Jul 2007
Posts: 70
journeyman
|
journeyman
Joined: Jul 2007
Posts: 70 |
Ok looking at the tables it told me the table was in uses so I fixed table and got.
messageboard.ubbt_REFERER_LOG repair status OK
So will see of that fixes my problem!
I NEED TO SAY I LOVE UBB.threads and the support you get! Thank you so much for your time! the UBB.threads is a big part of our Network!!
Best Regards Danny de Hek - Below is our Office Cam Image
|
|
|
|
Joined: Jun 2006
Posts: 16,299 Likes: 116
|
Joined: Jun 2006
Posts: 16,299 Likes: 116 |
I think that the timestamps in the database are stored in unix time, so the date preference and offset don't matter...
|
|
|
Bots
by Outdoorking - 04/13/2024 5:08 PM
|
|
|
|
|
|
1 members (1 invisible),
859
guests, and
196
robots. |
Key:
Admin,
Global Mod,
Mod
|
|
|
|