- Posts: 11
- Thank you received: 0
issues installing on IIS with SQL-server
- HenkN
- Topic Author
- Offline
- New Member
Less
More
4 years 5 months ago #13574
by HenkN
issues installing on IIS with SQL-server was created 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.
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.
- Dima
- Offline
- Platinum Member
4 years 5 months ago - 4 years 5 months ago #13577
by Dima
Don't forget support my developments: post review in JED , donate , help with translation
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
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 translation
Last edit: 4 years 5 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
4 years 5 months 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.
- Dima
- Offline
- Platinum Member
4 years 5 months ago #13579
by Dima
Don't forget support my developments: post review in JED , donate , help with translation
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
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 translation
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
4 years 5 months 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.
Please Log in or Create an account to join the conversation.
Time to create page: 0.212 seconds