Re: [mv] 3.14-4.04 Migration Confusion

[Hans-Joachim Leidinger <jojo@buchonline.net>]

******    message to minivend-users from Hans-Joachim Leidinger <jojo@buchonline.net>     ******

Barney Treadway schrieb:
> 
> ******    message to minivend-users from Barney Treadway <barney@wttech.com>     ******
> 
> Many thanks Cameron,
> 
> I have done as you suggested (deleting all file.sql) and the errors
> continue, and erratic as well which makes diagnosis difficult. I dropped all
> tables and _including_ the mv_test_create and get part way through this.
> Sometimes it appears to choke creating users, sometimes shipping.. this is
> the last try log (edited for list sanity!)
> 
> [usr145@widgr0003atl2 mvend]$ bin/restart
> Killing Minivend server 1282 with TERM.
> Low traffic settings.
> MiniMate is NOT active.
> MiniVend V4.04
> Configuring catalog demo...
> Using MySQL for databases, DSN=dbi:mysql:demo.
> 
> ConfigDatabase scalar parameter USER redefined to 'myuser', was myuser.
> In line 4 of the configuration file 'mysql/pricing.mysql.old':
> Database  pricing  USER         __SQLUSER__
> 
> ConfigDatabase scalar parameter PASS redefined to 'mypass', was mypass.
> In line 7 of the configuration file 'mysql/pricing.mysql.old':
> Database  pricing  PASS         __SQLPASS__
> 
> ConfigDatabase scalar parameter KEY redefined to 'sku', was sku.
> In line 9 of the configuration file 'mysql/pricing.mysql.old':
> Database  pricing  KEY          sku
> 
> table userdb created: create table userdb (
> username char(16) NOT NULL,
> ...snip...
> and on and on, apparently correctly
> ..snip...
[DEL]
 
> Error: Table 'mv_test_create' already exists
> demo config error: Can't call method "set_row" on an undefined value at
> (eval 49
> ) line 7, <IN> chunk 2.
> 
> -------------
> Again, mv_test_create was dropped before restart, so it shouldn't have
> "existed".
> 

[DEL]
> In line 9 of the configuration file 'mysql/pricing.mysql.old':
> Database  pricing  KEY          sku
> 
> bad table creation statement:
> create table shipping (
> ..snip..
[DEL]
> Going crazy here, if someone else has been through this hell, please show me
> the exit.

Barney,

did you look into the webspace, where all the files of your catalogs is
(are?)?
I get the above messages often and always, if I changes the sql files
and use the makecat script once more. I get such kind of file list like

(1) /www/minivendwebspace/catalogs/myshop/mysql/products.mysql
(2) /www/minivendwebspace/catalogs/myshop/mysql/products.mysql~
etc.

because, I use xemacs, which make a backup files with
"<nameofthefile>~".

What happen?
1. at (1) ---> OK!
2. at (2) ---> > blah blah ... redefined ... blah blah

If all tables was dropped and a new tables is to creat by minivend

1. at (1) ---> OK!
2. at (2) ---> > Error: Table 'products' already exists

Hint: Enable the SQL-Log and use "tail -f path-to-the-sql-logfile".

Regards,

	Joachim

-- 
-------------Hans-Joachim Leidinger---------------------


-
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