issues installing on IIS with SQL-server

  • HenkN
  • Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
More
2 months 3 days 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.
Attachments:

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

More
2 months 3 days ago - 2 months 3 days ago #13577 by Dima
Replied by Dima on topic issues installing on IIS with SQL-server
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

Don't forget support my developments: post review in JED , donate , help with thanslation ;)
Last edit: 2 months 3 days ago by Dima.

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

  • HenkN
  • Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
More
2 months 3 days ago #13578 by HenkN
Replied by HenkN on topic issues installing on IIS with SQL-server
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.

More
2 months 3 days ago #13579 by Dima
Replied by Dima on topic issues installing on IIS with SQL-server
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

Don't forget support my developments: post review in JED , donate , help with thanslation ;)

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

  • HenkN
  • Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
More
2 months 3 days ago #13581 by HenkN
Replied by HenkN on topic issues installing on IIS with SQL-server
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.
Attachments:

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

Time to create page: 0.052 seconds

Donate


Go to top