Totally Zenned
- Join Date:
- Apr 2009
- Posts:
- 507
- Plugin Contributions:
- 1
Documentation Plugin SQL Installation
ZC 1.5.7
Trying to write a new plugin. I have a few questions re the SQL installer Class and how to write one if i need to.
The current version of zen cart reports errors if you use multi line SQL for use in install sql patch in zen cart admin. so
Does the new installer method use the same validation and have the same requirements for multi line sql as the install sql patch in admin? e.g.
I want to run the following Query
INSERT IGNORE INTO products_location (products_id, products_location)
SELECT products_id,"" FROM products ;
to cope with the select from products in the insert it needs to be on a new line.
Is this still true if I just use straight sql for the install and will it still produce the same erroneous error message?
You quote in the documentation an example of how to create an installer class. However there is no link to the plugin. When I look at the plugins i can find the one quoted but is does not use the installer class. Does the example exist? if so can i see it? It may be easier to code a sql installer than it is to correct the issue above.
