Previous Thread
Next Thread
Print Thread
Hop To
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

Quote
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

[Linked Image from newzealandnz.co.nz]
Joined: Dec 2003
Posts: 6,560
Likes: 78
Joined: Dec 2003
Posts: 6,560
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,560
Likes: 78
Joined: Dec 2003
Posts: 6,560
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

Quote
[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

[Linked Image from newzealandnz.co.nz]
Joined: Jun 2006
Posts: 16,292
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,292
Likes: 116
Quote
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.


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
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

[Linked Image from newzealandnz.co.nz]
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

[Linked Image from newzealandnz.co.nz]
Joined: Jun 2006
Posts: 16,292
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,292
Likes: 116
I think that the timestamps in the database are stored in unix time, so the date preference and offset don't matter...


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!

Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
spam issues
by ECNet - 03/19/2024 11:45 PM
Looking for a forum
by azr - 03/15/2024 11:26 PM
Editing Links in Post
by Outdoorking - 03/15/2024 9:31 AM
Question on barkrowler and the like
by Mors - 02/29/2024 6:51 PM
Member Permissions Help
by domspeak - 02/27/2024 6:31 PM
Who's Online Now
0 members (), 744 guests, and 147 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
Los Angeles
Los Angeles
by isaac, August 6
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Stones
Stones
by isaac, August 19
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20230217)