- Posts: 11
 - Thank you received: 0
 
issues installing on IIS with SQL-server
- HenkN
 - Topic Author
 - Offline
 - New Member
 - 
            
         
        Less
        More
        
            
    
        
            
        
                5 years 4 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
 - 
            
         
            
        
                5 years 4 months ago         -  5 years 4 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: 5 years 4 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
 
            
        
                5 years 4 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
 - 
            
         
            
        
                5 years 4 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
 
            
        
                5 years 4 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.187 seconds