Multi Vendor / Dropshipper vQmod Module Installation Error

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/mydomain/public_html/mydomain.co.uk/vqmod/vqcache/vq2-system_library_user.php on line 26Notice: Undefined index: cat_permission in/home/mydomain/public_html/mydomain.co.uk/vqmod/vqcache/vq2-system_library_user.php on line 27Notice: Undefined index: vendor_permission in /home/mydomain/public_html/mydomain.co.uk/vqmod/vqcache/vq2-system_library_user.php on line28Notice: Undefined index: folder in /home/mydomain/public_html/mydomain.co.uk/vqmod/vqcache/vq2-system_library_user.php on line 29Notice: Undefined index: user_date_start in /home/mydomain/public_html/mydomain.co.uk/vqmod/vqcache/vq2-system_library_user.php on line 30Notice: Undefined index: user_date_end in /home/mydomain/public_html/mydomain.co.uk/vqmod/vqcache/vq2-system_library_user.php on line 30Notice: Undefined index: user_date_start in/home/mydomain/public_html/mydomain.co.uk/vqmod/vqcache/vq2-system_library_user.php on line 30

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

This code you've posted shows that there is no DB_PREFIX set, which is fairly unlikely...so do you have a db prefix set? If so, that's the issue.