jOpenSimWorld

Grid Status: Online
Total Regions: 23
Visitors (30 Days): 12
Total Residents: 479
Online Now: 0
Hypergriders online: 0

Component Install: SQL error

12 years 10 months ago #887 by Samuel
Hello

When i try to install the new com_opensim i get the following error.

Component Install: SQL error or missing or unreadable SQL file. DB function reports no errors

I use Joomla 1.5.22

I checked the xml file, and there the driver is set to mysql.

Anyone knows what to do?

Please Log in or Create an account to join the conversation.

12 years 10 months ago - 12 years 10 months ago #888 by foto50
Hello Samuel

Are you trying to upgrade an existing com_opensim installation or install a fresh one?

Also: do you have access to the "error_log" from your webserver? Sometimes there's more info in there about what's going wrong.

Greetz
FoTo50

Please Log in or Create an account to join the conversation.

12 years 10 months ago #889 by Samuel
This is a fresh installation.

Could you please tell me what the requirements are besides Joomla?

Because when i switch to newer versions of mysql or php, install will also fail on the older Com opensim.

I tried Mysql 5.5 now, but then i get a error 1064 on installing the component.
For the new version the error stays the same, i did a full reinstall on everything i use (Wamp 2.1,Joomla).

It seems i always have to fight with both. hahaha.. still. reverting to wamp 2 and com opensim 0.1.8.. everything works fine.

Please Log in or Create an account to join the conversation.

12 years 10 months ago #890 by foto50
Hi Samuel

I did a Wamp Install on my laptop today and got the same failure like you. The same zip installs fine on Lamp ... strange ...

It somehow seems that it cannot read the sql file for creating the database tables on Wamp. I'll investigate that closer and will let you know as soon as I found a solution.

Greetz
FoTo50

Please Log in or Create an account to join the conversation.

12 years 10 months ago #891 by foto50
There was an issue with recognizing the sql file within Wamp that I could not really identify exact. However I changed the installation routine and uploaded a new version (0.1.9.3) that should now work with Lamp AND Wamp ;)

Greetz
FoTo50

Please Log in or Create an account to join the conversation.

12 years 10 months ago #893 by Samuel
Hey :)

Thats awesome.. thank you so much.. will try it right away :)

and will let you know within a few mn :)

Please Log in or Create an account to join the conversation.

12 years 10 months ago #894 by Samuel
Ok that works better :)

the Xml error is gone.
But :) even with version. my Tab notices is still greyed out.

Please Log in or Create an account to join the conversation.

12 years 10 months ago - 12 years 10 months ago #895 by rjspence
Component Install: SQL error or missing or unreadable SQL file. DB function reports no errors

#__opensim_inworldident
#__opensim_mapinfo
#__opensim_group

$ mysql -V
mysql Ver 14.14 Distrib 5.1.57, for debian-linux-gnu (i486) using readline 6.2

Please Log in or Create an account to join the conversation.

Time to create page: 0.108 seconds

Search

Donate jOpenSim

Please consider supporting our efforts.

Amount

Our Regions

Region: Loc X: Loc Y:
Agora 1000 998
BareBad… 997 997
Bohemas 996 998
BoraBor… 1002 999
Crystal… 1001 1000
DeepTho… 1005 998
FoToSan… 999 995
jCity 1001 997
jOpenWe… 1000 999
JuniorT… 1002 1001
Kanadah… 1002 1000
LindaKe… 1000 997
LittleC… 996 997
MonteSc… 1001 1001
Naos 999 999
Pangaea 1005 1003
RiverSi… 999 1000
Sakani 999 998
Snambin 1001 998
Tartola 997 998
ViewerH… 1002 998
WaterWo… 1001 999
WilderK… 1000 1000

jOpenSimWorld

Grid Status: Online
Total Regions: 23
Visitors (30 Days): 12
Total Residents: 479
Online Now: 0
Hypergriders online: 0