Hi
I bought the Waabay multi vendor module (vqmod) version a while back for a project and we are just starting to put it together but I am having issues installing it to test.
I have followed the instructions but when I try to import the .sql file I get an error message:
Error
SQL query:
-- Dumping permission fields to `user` table
ALTER TABLE user ADD cat_permission text COLLATE utf8_bin NOT NULL;
MySQL said: Documentation
#1146 - Table 'mydatabase_mydatabase.user' doesn't exist
Can you please advise what the error is and what I can do to solve this issue. Plus in the back office I have alot of permission warnings in the vqmod folder:
Notice: Undefined index: store_permission in /home/u862502023/public_html/vqmod/vqcache/vq2-system_library_user.php on line 26Notice: Undefined index: cat_permission in /home/u862502023/public_html/vqmod/vqcache/vq2-system_library_user.php on line 27Notice: Undefined index: vendor_permission in /home/u862502023/public_html/vqmod/vqcache/vq2-system_library_user.php on line 28Notice: Undefined index: folder in /home/u862502023/public_html/vqmod/vqcache/vq2-system_library_user.php on line 29Notice: Undefined index: user_date_start in /home/u862502023/public_html/vqmod/vqcache/vq2-system_library_user.php on line 30Notice: Undefined index: user_date_end in /home/u862502023/public_html/vqmod/vqcache/vq2-system_library_user.php on line 30Notice: Undefined index: user_date_start in /home/u862502023/public_html/vqmod/vqcache/vq2-system_library_user.php on line 30Notice: Undefined index: store_permission in /home/u862502023/public_html/vqmod/vqcache/vq2-system_library_user.php on line 63Notice: Undefined index: cat_permission in /home/u862502023/public_html/vqmod/vqcache/vq2-system_library_user.php on line 64Notice: Undefined index: vendor_permission in /home/u862502023/public_html/vqmod/vqcache/vq2-system_library_user.php on line 65Notice: Undefined index: folder in /home/u862502023/public_html/vqmod/vqcache/vq2-system_library_user.php on line 66Notice: Undefined index: user_date_start in /home/u862502023/public_html/vqmod/vqcache/vq2-system_library_user.php on line 67Notice: Undefined index: user_date_end in /home/u862502023/public_html/vqmod/vqcache/vq2-system_library_user.php on line 67Notice: Undefined index: user_date_start in /home/u862502023/public_html/vqmod/vqcache/vq2-system_library_user.php on line 67Warning: Cannot modify header information - headers already sent by (output started at /home/u862502023/public_html/admin/index.php:85) in /home/u862502023/public_html/vqmod/vqcache/vq2-system_engine_controller.php on line 28Warning: Cannot modify header information - headers already sent by (output started at /home/u862502023/public_html/admin/index.php:85) in /home/u862502023/public_html/vqmod/vqcache/vq2-system_engine_controller.php on line 29
I think this may be due to the fact that as I am unable to import the .sql file then I am unable to amend the permissions.
Any help would be great as I really need this to work.
Regards
jay
Thats strange, I thought it was just me
I have one site running opencart 1.5.5.1 with a xml file that works aok
I have recently uploaded opencart 1.5.6.4 and the latest version of VQmod 2.4.1, and running the same xml file I get what you get
What appears to be happening is the ALTER TABLE - ADD for the mysql database is not inserting the columns
As a short fix I have had to go to my mysql database and insert the columns the the table I need from there and when I run the xml program again it works fine
still have not worked out the cause and still trying to solve
hopefully a really clued up sql / xml developer could just answer this problem
I have one site running opencart 1.5.5.1 with a xml file that works aok
I have recently uploaded opencart 1.5.6.4 and the latest version of VQmod 2.4.1, and running the same xml file I get what you get
What appears to be happening is the ALTER TABLE - ADD for the mysql database is not inserting the columns
As a short fix I have had to go to my mysql database and insert the columns the the table I need from there and when I run the xml program again it works fine
still have not worked out the cause and still trying to solve
hopefully a really clued up sql / xml developer could just answer this problem
Who is online
Users browsing this forum: No registered users and 73 guests