dsn

[Guest]

ok, I am the previus anonimus user. I installed the mysql driver from the link made a file dsn witch pointed to my external mysql server. Then tested it, worked fine. I then pointed my file dsn in authentiaction tab to that file dsn.
now i get this error.



Warning: odbc_result(): Field eminutes not found in c:\program files\firstspot\cfgmgr\users.php on line 526

[alan]

Make sure you create the table using the current version of the "create table" statement within firstspot_guide.pdf. Note that there is a table definition change in v3.0.4 ( refer to http://www.patronsoft.com/forum/viewtopic.php?t=381 )

My guess is that your table was created using the pre-v3.0.4 create table statement within firstspot_guide.pdf (but you are using v3.0.4 right now).

(Of course, we cannot rule out it is a FirstSpot issue. But please double-check your create table statement first)
_________________
~ Patronsoft Limited ~

[newguy]

Good Call. It was the new pdf sql statment that worked.

[newguy]

Ok, now I have another one. When the datat base is upgraded with a new and inproved data tables. How are we going to keep from losing our data base. Can you guys make some upgrade sql table staements to avoid this problem.

[kevin]

You can export the tables into CSV format and then import it back to the new tables. The function is under the User tab inside Configuration Manager.
_________________
~ Patronsoft Limited ~