View previous topic :: View next topic |
Author |
Message |
Guest
|
Posted: Fri Jan 28, 2005 9:45 pm Post subject: dsn |
|
|
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 |
|
Back to top |
|
|
alan Forum facilitator
Joined: 26 Sep 2003 Posts: 4435
|
Posted: Sat Jan 29, 2005 5:50 pm Post subject: |
|
|
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 ~ |
|
Back to top |
|
|
newguy
Joined: 29 Jan 2005 Posts: 3
|
Posted: Sat Jan 29, 2005 7:19 pm Post subject: dsn |
|
|
Good Call. It was the new pdf sql statment that worked. |
|
Back to top |
|
|
newguy
Joined: 29 Jan 2005 Posts: 3
|
Posted: Sat Jan 29, 2005 7:23 pm Post subject: dsn |
|
|
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. |
|
Back to top |
|
|
kevin Forum facilitator
Joined: 26 Sep 2003 Posts: 442
|
Posted: Sun Jan 30, 2005 3:14 am Post subject: |
|
|
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 ~ |
|
Back to top |
|
|
|
|
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
|
|
Powered by phpBB © 2001, 2005 phpBB Group
| |