1
RRice
Constant Database Errors
  • 2006/4/10 12:02

  • RRice

  • Just popping in

  • Posts: 22

  • Since: 2006/2/28


Hi. First off, if this sin't the right forum, please move this post?

For awhile now, i have been going over XOOPS in the site created for my on-line game community. Everyone loves the site and we have had no issues until recently.

It seem's that everytime one of the admins or myself try to add content to the site, whether it's a block or a module, we have to log into the admin panel and re-install that specific module for the content to be updated. We have never had to do this before. I'm not sure what is causing this issue. I doubled checked the server from our host and they state that the server is XOOPS compatible.

We have even had some difficulties with some modules giving us errors after trying to add content. And all it says is Database Error. I did a search for database errors and didn't find anything. Anyone have a clue as to why we have to keep reinstalling/updating the database everytime we add content?

I am also wondering if this is the reason why the "remember me" doesn't work. I downloaded the files for the version i'm running, everything seemed to work great. But it doesn't remember you from your last login in. And now i can't remember where i downloaded it from to go check the forums there.

Is this all user error? or is there something else wrong? You can look at the site here:
http://www.187platoon.clanservers.com

Thanks in advanced.

2
jensclas
Re: Constant Database Errors

Hi there...
Quote:
"remember me" doesn't work.


I'm certain if you run a search on that here you are likely to find something.

Can you please give the gurus the essentials - xoops, mysql, php etc versions?

Perhaps you might also report anything you come up with in php debug and MySQL debug.

With a bit more information like this someone is likely to be able to offer specific help. (PS - I am not one of the gurus in these areas...)

3
RRice
Re: Constant Database Errors
  • 2006/4/10 22:32

  • RRice

  • Just popping in

  • Posts: 22

  • Since: 2006/2/28


Xoops Ver 2.0.13.2
PHP ver. 4.4.0
SQL Ver. 4.0.25 Standard
Sever- Linux
SQL Database size 2.19mb

MySQL Account Maintenance

Checking Database
cs193276_platoonsite is now being checked
.

cs193276_platoonsite.xoops_avatar                  OK
cs193276_platoonsite
.xoops_avatar_user_link        OK
cs193276_platoonsite
.xoops_banner
warning  
1 client is using or hasn't closed the table properly
status   : OK
cs193276_platoonsite.xoops_bannerclient            OK
cs193276_platoonsite.xoops_bannerfinish            OK
cs193276_platoonsite.xoops_bb_categories           OK
cs193276_platoonsite.xoops_bb_forum_access         OK
cs193276_platoonsite.xoops_bb_forum_mods           OK
cs193276_platoonsite.xoops_bb_forums               OK
cs193276_platoonsite.xoops_bb_posts                OK
cs193276_platoonsite.xoops_bb_posts_text           OK
cs193276_platoonsite.xoops_bb_topics               OK
cs193276_platoonsite.xoops_block_module_link       OK
cs193276_platoonsite.xoops_config                  OK
cs193276_platoonsite.xoops_configcategory          OK
cs193276_platoonsite.xoops_configoption            OK
cs193276_platoonsite.xoops_group_permission        OK
cs193276_platoonsite.xoops_groups                  OK
cs193276_platoonsite.xoops_groups_users_link       OK
cs193276_platoonsite.xoops_image                   OK
cs193276_platoonsite.xoops_imagebody               OK
cs193276_platoonsite.xoops_imagecategory           OK
cs193276_platoonsite.xoops_imgset                  OK
cs193276_platoonsite.xoops_imgset_tplset_link      OK
cs193276_platoonsite.xoops_imgsetimg               OK
cs193276_platoonsite.xoops_modules                 OK
cs193276_platoonsite.xoops_myalbum_cat             OK
cs193276_platoonsite.xoops_myalbum_photos          OK
cs193276_platoonsite.xoops_myalbum_text            OK
cs193276_platoonsite.xoops_myalbum_votedata        OK
cs193276_platoonsite.xoops_mylinks_broken          OK
cs193276_platoonsite.xoops_mylinks_cat             OK
cs193276_platoonsite.xoops_mylinks_links           OK
cs193276_platoonsite.xoops_mylinks_mod             OK
cs193276_platoonsite.xoops_mylinks_text            OK
cs193276_platoonsite.xoops_mylinks_votedata        OK
cs193276_platoonsite.xoops_newblocks               OK
cs193276_platoonsite.xoops_online                  OK
cs193276_platoonsite.xoops_priv_msgs               OK
cs193276_platoonsite.xoops_ranks                   OK
cs193276_platoonsite.xoops_seccont                 OK
cs193276_platoonsite.xoops_sections                OK
cs193276_platoonsite.xoops_session                 OK
cs193276_platoonsite.xoops_smiles                  OK
cs193276_platoonsite.xoops_stories                 OK
cs193276_platoonsite.xoops_stories_files           OK
cs193276_platoonsite.xoops_stories_votedata        OK
cs193276_platoonsite.xoops_team_availability       OK
cs193276_platoonsite.xoops_team_ladders            OK
cs193276_platoonsite.xoops_team_layout             OK
cs193276_platoonsite.xoops_team_lineups_positions  OK
cs193276_platoonsite.xoops_team_mappool            OK
cs193276_platoonsite.xoops_team_matches            OK
cs193276_platoonsite.xoops_team_matchmaps          OK
cs193276_platoonsite.xoops_team_positions          OK
cs193276_platoonsite.xoops_team_rank               OK
cs193276_platoonsite.xoops_team_server             OK
cs193276_platoonsite.xoops_team_sides              OK
cs193276_platoonsite.xoops_team_sizes              OK
cs193276_platoonsite.xoops_team_skills             OK
cs193276_platoonsite.xoops_team_status             OK
cs193276_platoonsite.xoops_team_tactics            OK
cs193276_platoonsite.xoops_team_tactics_positions  OK
cs193276_platoonsite.xoops_team_team               OK
cs193276_platoonsite.xoops_team_teamladders        OK
cs193276_platoonsite.xoops_team_teammaps           OK
cs193276_platoonsite.xoops_team_teampositions      OK
cs193276_platoonsite.xoops_team_teamrank           OK
cs193276_platoonsite.xoops_team_teamservers        OK
cs193276_platoonsite.xoops_team_teamsides          OK
cs193276_platoonsite.xoops_team_teamsizes          OK
cs193276_platoonsite.xoops_team_teamstatus         OK
cs193276_platoonsite.xoops_topics                  OK
cs193276_platoonsite.xoops_tplfile                 OK
cs193276_platoonsite.xoops_tplset                  OK
cs193276_platoonsite.xoops_tplsource               OK
cs193276_platoonsite.xoops_users                   OK
cs193276_platoonsite.xoops_xoopscomments           OK
cs193276_platoonsite.xoops_xoopsnotifications      OK
cs193276_platoonsite.xoops_xoopspoll_desc          OK
cs193276_platoonsite.xoops_xoopspoll_log           OK
cs193276_platoonsite.xoops_xoopspoll_option        OK


Check Complete



im not sure how to do a php debug or a sql debug. im not seeing anything in the control panel via my host for this, nor in the XOOPS control panel.

hope this info helps.

4
RRice
Re: Constant Database Errors
  • 2006/4/12 11:41

  • RRice

  • Just popping in

  • Posts: 22

  • Since: 2006/2/28


I think this may have helped caused the issue but i'm not sure...
Yesterday i tried to log into my site at work during lunch to check my messages. The entire database was gone. The server must have crashed or somthing. Because i couldn't even log into the control panel. Once i got home last night, the databse was back, but it was totally corrupted. I did find a way to import the back up i made last week. However, everything posted since then is missing. Not a big deal, at leat i don't have to do it all over again.

Here is my next question. Is there a way to have XOOPS do a scheduled back up of the database? Say like every wensday at midnight, this way, thursday morning i could log in and download it?

Thank you.

Login

Who's Online

426 user(s) are online (373 user(s) are browsing Support Forums)


Members: 0


Guests: 426


more...

Donat-O-Meter

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

Latest GitHub Commits