DCS conversion error

[Irpus]

Hi everyone.
I'm back for another attempt to setup SEOW! I do it because I really like it but, unfortunately, it seems not to like me!
Now my problem is with DCS.
I installed EasyPHP to have everything I need to use SEOW in a simple way.
I was able to setup the MP and, apparently, even the DB using phpMyAdmin and one of the split .sql files available (Last time I used ArdennesLite.sql ) . I install DCS and run it. When I insert DB data everything seems ok until I try to initialize the campaign. To do this, I use one of the templates available in the download section ( France1940 from jg11 or Tunis for example). When I hit the button to confirm the initialization, after a little time, I receive a message saying there is an incorrect conversion from Byte() to 'String'. There also appears another longer message that is about JIT debugger, but I will not post it until required.
I did search for something that could help me before posting, but I wasn't able to recognize anything useful, so any help would be very appreciated.
Thank You.

[Irpus]

Any advice on this error? Should I reinstall everything?
I already added the field for informational popups.
Now I get this error even when I try to set DB parameters (I cleared the fields trying to fix it).
Anyone used EasyPHP or phpMyAdmin to manage SEOW?

[IV/JG7_4Shades]

Hi Irpus,

Sorry about the delay, I have been away. Please post all your software revisions so we can see where you are at. Many people have used EasyPHP for SEOW successfully.

Cheers,
4Shades

[Irpus]

Hi 4Shades,
thanks for your reply.
Now I use another installation of MySQL and MySQLAdministrator to create the DB without errors. I use the Apache web server included in EasyPHP to manage the PHP applications and the other MySQL service for the DB. I know it sounds complicated, but I think the error was caused by phpMyAdmin when I used it to create the DB. However, it was probably my fault.
But now my DCS keeps giving me this problem. I tried everything mentioned in that thread (including setting up the Access DB that was recognized correctly), but without luck. I also uninstalled the DCS deleting to try again, but nothing changes.
I have experienced this error before but I always managed to solve it simply doing as adviced in the thread linked above.
I don't know if this is caused by my separate installation of mysql.
I use the following version of the SEOW software:

- SEDCS 3.1.1
- MP 4.360b
- Files .sql included in SEDB31_MySQL_Unix_Reference.zip

Other software used:
- Win XP SP2
- .NET Framework 2.0
- EasyPHP 2.0b (mysql on port 3307)
- MySQL ODBC Connector 3.51
- MySQL Server 5.0.37 (I use MySQL51 as the name of the service...) on port 3306

Hope it's all you need to know.
Thank You again.
Bye,
Irpus.

[IV/JG7_4Shades]

Hi Irpus,

You can have as many different MySQL servers on different port numbers as you like, so running two servers shouldn't be a problem, as long as you don't mix them up. E.g., you need to make sure that the DCS and the MP are pointing at the same server.

I have only rarely encountered the DCS error you reference. In such cases I clear both MySQL and MSAccess DB connections, then close down the DCS. A DCS restart fixes the problem for me. This only happens once every 6 months or so for me, which is rare given the number of times I build and deploy DCS code revisions.

Maybe this doesn't help you, but I am not sure what would help.

Cheers,
4Shades

[Goanna]

would updating the DCS to 3.1.3 and MP to 373 help?

Cheers

Goanna

[Irpus]

Problem solved.
First of all thanks for your help.
I solved assigning all permissions on my DB to the user I created. That is, maybe the permissions suggested in the install guide are not enough. I will try to understand exactly which permissions are really needed, if useful.
Now my SEOW is operational in local mode and I'm trying to understand what is not going well for the external access from the internet (I opened one port on my modem/router to let my friend to try and assigned that port to Apache in the Listen parameter)
Thanks again.

Irpus.

PS. I also upgraded to SEDCS 3.1.3 and MP 4.373, but it did not work.
And I also noticed that the icons are not loaded on the map, any clue?

[IV/JG7_4Shades]

Hi Irpus,

Icons are referenced from a path on the web server that is specified inside MP-Configuration.php. Edit this file to set the appropriate path.

Opening your Apache port is the right thing to do if you want external users to see your MP. Note that if you are running some security software on your server (e.g. Windows Firewall or ZoneAlarm) you will have to ensure that the security software permits traffic on that port too (not just the router).

Cheers,
4Shades