Re: [mv] [Follow-up] MV4 SQL Problem with userdb

["Christian J. Müller" <cmueller@polinet.ch>]

Just after having sent this post, I noticed that the entries in the
mySQL userdb are correct. 
Interesting: KMySQL Client shows correct entries, whereas KMySQL Admin
shows incorrect entries!
Chris

"Christian J. Müller" wrote:
> 
> ******    message to minivend-users from "Christian J. =?iso-8859-1?Q?M=FCller?=" <cmueller@polinet.ch>     ******
> 
> The installation of the SQL simple version of MV4 went very smoothly. It
> is my first SQL installation. All I really needed to do was to create th
> test_minivend database in mySQL, then run makecat - and there it was and
> worked!
> Now, I have some problem with the userdb. My registration works and the
> user is recorded in mySQL userdb. However, when I try to log in, theere
> is no reaction and no error messages on the page nor in error_log. When
> I try to register again, the username already exists.
> As I checked the mySQL userdb, I noticed that in the 3rd colom (acl)
> there is a timestamp. The Country entry is two fiels off, the same
> applies to the mv_shipmode. (I have no other entries so far). I have
> added [tag export userdb][/tag] to the new_account page and can see,
> that the timestamp is not in the acl colum, but (correctly) in the
> mod_time column. There seems to be a discrepancy between userdb.txt and
> mySQL userdb.
> 
> Has anyone else had this problem? Is this a problem that I may have
> caused due to lack of experience with SQL? I would be surpriced, since I
> have done nothing else but created a mySQL Database test_minivend and
> allocated global priviledges to minivend (owner of minivend).
> Any hints would be highly appreciated.
> Chris
> -
> To unsubscribe from the list, DO NOT REPLY to this message.  Instead, send
> email with 'UNSUBSCRIBE minivend-users' in the body to Majordomo@minivend.com.
> Archive of past messages: http://www.minivend.com/minivend/minivend-list