Everything worked fine so far, since more than two years now, but now I get very strange errors.
First, tried to hire a new player for an existing team. Error message :
"PROCEDURE 37897m27672_3.getPlayerRels does not exist" (37897m27672_3 is the name of the database)
Player existed after that but with 0000 stat line and MNG.
Then tried to fire this player. Error :
"PROCEDURE 37897m27672_3.getPlayerDProps does not exist"
Nevertheless player is gone.
Tried to create a new team. Error :
"PROCEDURE 37897m27672_3.getTeamDProps does not exist" again. Team existed after that but without race and coach entries.
Link to the web site : http://www.bomfur.de/obblm/index.php?section=main
Any ideas how to fix this ?
OBBLM weird problem
Moderator: TFF Mods
- Shteve0
- Legend
- Posts: 2479
- Joined: Thu May 07, 2009 10:15 am
- Location: Wellington, New Zealand
Which team?
Second question, have you updated anything lately?
Second question, have you updated anything lately?
Reason: ''
League and tournament hosting, blogging and individual forums - all totally free. For the most immersive tabletop sports community experience around, check out theendzone.co
- Shteve0
- Legend
- Posts: 2479
- Joined: Thu May 07, 2009 10:15 am
- Location: Wellington, New Zealand
Without seeing the exact issue, I'd suggest checking your log for anything unusual and running the database sync tools.
Edit: Actually, maybe also check your php/sql versions haven't changed - could be worth confirming with your host whether that's the case.
Edit: Actually, maybe also check your php/sql versions haven't changed - could be worth confirming with your host whether that's the case.
Reason: ''
League and tournament hosting, blogging and individual forums - all totally free. For the most immersive tabletop sports community experience around, check out theendzone.co
-
- Experienced
- Posts: 150
- Joined: Mon Jan 30, 2012 8:19 am
Re: OBBLM weird problem
@Shteve0 - thanks for the reply !
It seems to be a provider problem. I exported the database, downloaded all files and imported everything to a local XAMPP installation. Here at least the issues mentioned above do not occur.
Neither on the original website nor in XAMPP I can´t access the core panel. On the website an empty page comes up, in XAMPP I get an error message (Parse error: syntax error, unexpected 'match_id' (T_STRING) in D:\xampp-portable\htdocs\forum\obblm\lib\class_sqlcore.php on line 96).
Versions :
1. Website :
Database Server Version: 5.6.30 - Source distribution
Apache/2.2.31
Database-Client Version: libmysql - mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $
PHP-Extension: mysqli
2.XAMPP
Software version: 5.5.27 - MySQL Community Server (GPL)
Apache/2.4.3 (Win32) OpenSSL/1.0.1c PHP/5.4.7
Database client version: libmysql - mysqlnd 5.0.10 - 20111026 - $Id: b0b3b15c693b7f6aeb3aa66b646fee339f175e39 $
PHP extension: mysql
Is the highlighted difference of any significance ?
Thanks a lot for helping !
It seems to be a provider problem. I exported the database, downloaded all files and imported everything to a local XAMPP installation. Here at least the issues mentioned above do not occur.
Neither on the original website nor in XAMPP I can´t access the core panel. On the website an empty page comes up, in XAMPP I get an error message (Parse error: syntax error, unexpected 'match_id' (T_STRING) in D:\xampp-portable\htdocs\forum\obblm\lib\class_sqlcore.php on line 96).
Versions :
1. Website :
Database Server Version: 5.6.30 - Source distribution
Apache/2.2.31
Database-Client Version: libmysql - mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $
PHP-Extension: mysqli
2.XAMPP
Software version: 5.5.27 - MySQL Community Server (GPL)
Apache/2.4.3 (Win32) OpenSSL/1.0.1c PHP/5.4.7
Database client version: libmysql - mysqlnd 5.0.10 - 20111026 - $Id: b0b3b15c693b7f6aeb3aa66b646fee339f175e39 $
PHP extension: mysql
Is the highlighted difference of any significance ?
Thanks a lot for helping !
Reason: ''
- Vanguard
- Super Star
- Posts: 922
- Joined: Sun Jun 08, 2008 8:27 am
- Location: Glasgow
- Contact:
Re: OBBLM weird problem
The error messages you are getting refer to MySQL Procedures that are part of the database (they do the grunt work in adding/removing teams and players and making sure the changes are reflected in all areas of the database) and for some reason they cannot be located.
I assume your website has been up and running successfully prior to this? This isn't a fresh install that you're having trouble with?
The confusing part is that the exported copy seems to work fine. The procedures would be exported as part of the backup process - so presumably they had to exist in the original in order to export. That suggests that it is some kind of permissions or config issue on your database server. I have known ISPs to restrict/prevent use of Procedures and Functions in MySQL. Might be worth checking that your hosting company haven't recently changed their policy.
The error regarding the Core Admin page suggests a syntax error in the class_sqlcore.php file but (unless you've altered the file) that should affect all OBBLM installations. Might be worth replacing it with a fresh copy from a current download.
Also, which version of OBBLM are you running?
I assume your website has been up and running successfully prior to this? This isn't a fresh install that you're having trouble with?
The confusing part is that the exported copy seems to work fine. The procedures would be exported as part of the backup process - so presumably they had to exist in the original in order to export. That suggests that it is some kind of permissions or config issue on your database server. I have known ISPs to restrict/prevent use of Procedures and Functions in MySQL. Might be worth checking that your hosting company haven't recently changed their policy.
The error regarding the Core Admin page suggests a syntax error in the class_sqlcore.php file but (unless you've altered the file) that should affect all OBBLM installations. Might be worth replacing it with a fresh copy from a current download.
Also, which version of OBBLM are you running?
Reason: ''
-
- Experienced
- Posts: 150
- Joined: Mon Jan 30, 2012 8:19 am
Re: OBBLM weird problem
I'm running OBBLM 0.95
Replacing class_sqlcore.php doesn´t solve the proble with the core panel.
I tried to copy the whole webspace to another (free) provider as a test but the problem ist the same as on the original webspace. Unfortunately I don´t have in depth information about PHP settings on both web providers.
Replacing class_sqlcore.php doesn´t solve the proble with the core panel.
I tried to copy the whole webspace to another (free) provider as a test but the problem ist the same as on the original webspace. Unfortunately I don´t have in depth information about PHP settings on both web providers.
Reason: ''