-
Forum
-
Zh OpenStreetMap
-
Plugin
-
issues installing on IIS with SQL-server
issues installing on IIS with SQL-server
-
HenkN
-
Topic Author
-
Offline
-
New Member
-
Less
More
-
Posts: 11
-
Thank you received: 0
-
-
3 years 9 months ago #13574
by HenkN
I have a good installation with ZH Openstreetmap on a public webserver. I'm now trying to install it on IIS with SQL server in my company.
Joomla installation OK;
Installation of ZH Openstreetmap OK;
In global admin I can make changes to the configuration of ZH Openstreetmap. But in Components>ZH openstreetmap I get errors for most menu topic's. About, Utilities, works. But all other menu items like Maps, Placemarks gives a SQL error message. See screenshots below.
Please Log in or Create an account to join the conversation.
Less
More
-
Posts: 4606
-
Thank you received: 460
-
-
-
-
-
3 years 9 months ago - 3 years 9 months ago #13577
by Dima
Hi.
Check if my extension tables are exist.
where #_ it is table prefix.
If it is not created, just unistall and install it again.
If it still not created, you can find installation script
com_zhosmmap\admin\sql\install.mysql.utf8.sql
edit it (replace #_ to your prefix), and execute it is SQL window on server
Last edit: 3 years 9 months ago by Dima.
Please Log in or Create an account to join the conversation.
-
HenkN
-
Topic Author
-
Offline
-
New Member
-
Less
More
-
Posts: 11
-
Thank you received: 0
-
-
3 years 9 months ago #13578
by HenkN
It seams the sql script is not compatible with SQL-server. It is designed for MySQL. On the SQL server I get a lot of errors. (back quote not accepted, auto_increment not accepted, engine= not accepted). I tried to solve the errors, but that's a lot of work.
Please Log in or Create an account to join the conversation.
Less
More
-
Posts: 4606
-
Thank you received: 460
-
-
-
-
-
3 years 9 months ago #13579
by Dima
I checked.
Yes, joomla has different installation forders for databases (sql, postgreesql, sqlazure). With different syntax.
I have only sql, that means MySQL. I haven't any installation of SQL-server, therefore I can't check how it works (or not). Sorry, I will think of it for furure
Please Log in or Create an account to join the conversation.
-
HenkN
-
Topic Author
-
Offline
-
New Member
-
Less
More
-
Posts: 11
-
Thank you received: 0
-
-
3 years 9 months ago #13581
by HenkN
Yes, I'm running in more issues. I created all necessary tables manually and got some ZH OSM working. But run in problems when I add a custom map style. See screenshots below. Same kind of error when uploading a csv file.
Please Log in or Create an account to join the conversation.
-
Forum
-
Zh OpenStreetMap
-
Plugin
-
issues installing on IIS with SQL-server
Time to create page: 0.187 seconds