Missing database table [#460054]

I am getting this error in the discounts module:

user warning: Table 'theherbc_Howies.uc_discounts' doesn't exist query: SELECT COUNT(*) FROM uc_discounts in /home/theherbc/public_html/Howies/sites/all/modules/uc_discounts_alt/uc_discounts/uc_discounts.admin.inc on line 26.
user warning: Table 'theherbc_Howies.uc_discounts' doesn't exist query: SELECT * FROM uc_discounts ORDER BY weight ASC LIMIT 0, 50 in /home/theherbc/public_html/Howies/sites/all/modules/uc_discounts_alt/uc_discounts/uc_discounts.admin.inc on line 26.

I am unsure on what to look for and get this resolved. I saw a bug report about missing tables and versioning information with php, but that was with an earlier version.
Any ideas?
This module is just what I have been needing.
Thx,
Z

Comments

Comment #1

ryangroe commented 12 May 2009 at 04:34

I believe the earlier missing table error was a dumb mistake I made (not tagging all the files in CVS). So I hope this isn't the same problem. Did you get any warnings/errors when installing the module? Also, did you upgrade to beta 25 from an earlier version of the module or is this a new installation? And have you tried uninstalling the module and re-installing?

Are you using a table prefix (perhaps 'theherbc_Howies')? Can you access the table names in your database and list all the tables containing "uc_discounts" (in phpMyAdmin just search for "uc_discounts" in your browser) in the name. The tables will all start with your table prefix. Thanks.

Comment #2

Zalatar commented 12 May 2009 at 14:45

I did get an error when enabling the module and it was stating that the table, in the above error, was not found. If I rememeber right.
This is a new install. So no previous versions. I just downloaded yesterday. I have tried disabling the module and reenabling it. Same error.
I have the following tables in my database:
uc_discounts_codes
uc_discounts_order_codes
uc_discounts_products
uc_discounts_roles
uc_discounts_terms
uc_discounts_uses

When I first installed the modules I enabled all UC_Discounts (alt) models and dependants at the same time. I then got errors. So I went back and disabled all of them. Then I did one at a time to see if that would fix the error. As of right now I am not getting an errors upon enabling the module. I get the above error when I try to create a discount. And when I go to checkout I see an error.

Hope this helps track down the issue.
Z

Comment #3

ryangroe commented 12 May 2009 at 17:10

So all the tables are there except the base table. Unfortunately to get the code to try to recreate it you'll have to disable then uninstall it, then install it again. Try that and let me know if there are any errors. Thanks.

Comment #4

Zalatar commented 12 May 2009 at 21:37

I uninstalled the module. I deleted the folder on my site. I redownloaded the module and installed it on my site. I enabled the "Discounts" module only and got the following errors when I saved the configuration.

Warning: MySQL server has gone away query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (1, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:12:\"user warning\";s:8:\"%message\";s:173424:\"MySQL server has gone away\nquery: UPDATE cache_update SET data = 'a:16:{s:6:\\"drupal\\";a:10:{s:5:\\"title\\";s:6:\\"Drupal\\";s:10:\\"short_name\\";s:6:\\"drupal\\";s:10:\\"dc:creator\\";s:6:\\"Drupal\\";s:11:\\"api_version\\";s:3:\\"6.x\\";s:17:\\"recommended_major\\";s:1:\\"6\\";s:16:\\"supported_majors\\";s:1:\\"6\\";s:13:\\"default_major\\";s:1:\\"6\\";s:14:\\"project_status\\" in /home/theherbc/public_html/Howies/includes/database.mysqli.inc on line 128

Warning: MySQL server has gone away query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (1, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:12:\"user warning\";s:8:\"%message\";s:130:\"MySQL server has gone away\nquery: UPDATE variable SET value = 'i:1242163654;' WHERE name = 'update_last_check'\";s:5:\"%file\";s:56:\"/home/theherbc/public_html/Howies/includes/bootstrap.inc\";s:5:\"%line\";i:519;}', 3, '', 'https://www.theherbcellar.com/Howies/admin/build/modules', 'https://www.theherbcellar.com/Howies/admin/build/modules', '97.125.165.96', 1242163654) in /home/theherbc/public_html/Howies/includes/database.mysqli.inc on line 128

Warning: MySQL server has gone away query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (1, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:12:\"user warning\";s:8:\"%message\";s:85:\"MySQL server has gone away\nquery: DELETE FROM cache WHERE cid = 'variables'\";s:5:\"%file\";s:52:\"/home/theherbc/public_html/Howies/includes/cache.inc\";s:5:\"%line\";i:179;}', 3, '', 'https://www.theherbcellar.com/Howies/admin/build/modules', 'https://www.theherbcellar.com/Howies/admin/build/modules', '97.125.165.96', 1242163654) in /home/theherbc/public_html/Howies/includes/database.mysqli.inc on line 128

Warning: MySQL server has gone away query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (1, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:12:\"user warning\";s:8:\"%message\";s:552:\"MySQL server has gone away\nquery: INSERT INTO watchdog\n (uid, type, message, variables, severity, link, location, referer, hostname, timestamp)\n VALUES\n (1, 'update', 'Fetched information about all available new releases and updates.', 'a:0:{}', 5, '<a href=\\"/Howies/admin/reports/updates\\">view</a>', 'https://www.theherbcellar.com/Howies/admin/build/modules', 'https://www.theherbcellar.com/Howies/admin/build/modules', '97.125.165.96', 1242163654)\";s:5:\"%file\";s:60:\"/home in /home/theherbc/public_html/Howies/includes/database.mysqli.inc on line 128

Warning: MySQL server has gone away query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (1, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:12:\"user warning\";s:8:\"%message\";s:102:\"MySQL server has gone away\nquery: DELETE FROM cache_update WHERE cid = 'update_project_data'\";s:5:\"%file\";s:62:\"/home/theherbc/public_html/Howies/modules/update/update.module\";s:5:\"%line\";i:580;}', 3, '', 'https://www.theherbcellar.com/Howies/admin/build/modules', 'https://www.theherbcellar.com/Howies/admin/build/modules', '97.125.165.96', 1242163654) in /home/theherbc/public_html/Howies/includes/database.mysqli.inc on line 128

Warning: MySQL server has gone away query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (1, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:12:\"user warning\";s:8:\"%message\";s:201074:\"MySQL server has gone away\nquery: UPDATE cache_update SET data = 'a:16:{s:6:\\"drupal\\";a:21:{s:4:\\"name\\";s:6:\\"drupal\\";s:4:\\"info\\";a:11:{s:4:\\"name\\";s:5:\\"Block\\";s:11:\\"description\\";s:62:\\"Controls the boxes that are displayed around the main content.\\";s:7:\\"package\\";s:15:\\"Core - required\\";s:7:\\"version\\";s:4:\\"6.11\\";s:4:\\"core\\";s:3:\\"6.x\\";s:7:\\"project\\";s:6 in /home/theherbc/public_html/Howies/includes/database.mysqli.inc on line 128

Warning: MySQL server has gone away query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (1, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:12:\"user warning\";s:8:\"%message\";s:174:\"MySQL server has gone away\nquery: SELECT data, created, headers, expire, serialized FROM cache_menu WHERE cid = 'links:primary-links:page-cid:admin/build/modules:1'\";s:5:\"%file\";s:52:\"/home/theherbc/public_html/Howies/includes/cache.inc\";s:5:\"%line\";i:26;}', 3, '', 'https://www.theherbcellar.com/Howies/admin/build/modules', 'https://www.theherbcellar.com/Howies/admin/build/modules', '97.125.165.96', 1242163654) in /home/theherbc/public_html/Howies/includes/database.mysqli.inc on line 128

Warning: MySQL server has gone away query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (1, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:12:\"user warning\";s:8:\"%message\";s:182:\"MySQL server has gone away\nquery: SELECT p1, p2, p3, p4, p5, p6, p7, p8 FROM menu_links WHERE menu_name = 'primary-links' AND link_path IN ('admin/build/modules')\";s:5:\"%file\";s:51:\"/home/theherbc/public_html/Howies/includes/menu.inc\";s:5:\"%line\";i:897;}', 3, '', 'https://www.theherbcellar.com/Howies/admin/build/modules', 'https://www.theherbcellar.com/Howies/admin/build/modules', '97.125.165.96', 1242163654) in /home/theherbc/public_html/Howies/includes/database.mysqli.inc on line 128

Warning: MySQL server has gone away query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (1, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:12:\"user warning\";s:8:\"%message\";s:179:\"MySQL server has gone away\nquery: SELECT p1, p2, p3, p4, p5, p6, p7, p8 FROM menu_links WHERE menu_name = 'primary-links' AND link_path = 'admin/build/modules'\";s:5:\"%file\";s:51:\"/home/theherbc/public_html/Howies/includes/menu.inc\";s:5:\"%line\";i:902;}', 3, '', 'https://www.theherbcellar.com/Howies/admin/build/modules', 'https://www.theherbcellar.com/Howies/admin/build/modules', '97.125.165.96', 1242163654) in /home/theherbc/public_html/Howies/includes/database.mysqli.inc on line 128

Warning: MySQL server has gone away query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (1, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:12:\"user warning\";s:8:\"%message\";s:179:\"MySQL server has gone away\nquery: SELECT mlid FROM menu_links WHERE menu_name = 'primary-links' AND expanded = 1 AND has_children = 1 AND plid IN (0) AND mlid NOT IN (0)\";s:5:\"%file\";s:51:\"/home/theherbc/public_html/Howies/includes/menu.inc\";s:5:\"%line\";i:916;}', 3, '', 'https://www.theherbcellar.com/Howies/admin/build/modules', 'https://www.theherbcellar.com/Howies/admin/build/modules', '97.125.165.96', 1242163654) in /home/theherbc/public_html/Howies/includes/database.mysqli.inc on line 128

Warning: MySQL server has gone away query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (1, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:12:\"user warning\";s:8:\"%message\";s:483:\"MySQL server has gone away\nquery: \n SELECT m.load_functions, m.to_arg_functions, m.access_callback, m.access_arguments, m.page_callback, m.page_arguments, m.title, m.title_callback, m.title_arguments, m.type, m.description, ml.*\n FROM menu_links ml LEFT JOIN menu_router m ON m.path = ml.router_path\n WHERE ml.menu_name = 'primary-links' AND ml.plid IN (0)\n ORDER BY p1 ASC, p2 ASC, p3 ASC, p4 ASC, p5 ASC, p6 ASC, p7 ASC, p8 ASC, p9 ASC\";s:5:\"%file\";s:51:\"/home/theherbc/public_html/Howies/includes/menu.inc\";s:5:\"%line\";i:940;}', 3, '', 'https://www.theherbcellar. in /home/theherbc/public_html/Howies/includes/database.mysqli.inc on line 128

Warning: MySQL server has gone away query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (1, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:12:\"user warning\";s:8:\"%message\";s:186:\"MySQL server has gone away\nquery: SELECT data, created, headers, expire, serialized FROM cache_menu WHERE cid = 'links:primary-links:tree-data:5d6d3aaaaef5fba302ce62698fa37bbe'\";s:5:\"%file\";s:52:\"/home/theherbc/public_html/Howies/includes/cache.inc\";s:5:\"%line\";i:26;}', 3, '', 'https://www.theherbcellar.com/Howies/admin/build/modules', 'https://www.theherbcellar.com/Howies/admin/build/modules', '97.125.165.96', 1242163654) in /home/theherbc/public_html/Howies/includes/database.mysqli.inc on line 128

Warning: MySQL server has gone away query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (1, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:12:\"user warning\";s:8:\"%message\";s:307:\"MySQL server has gone away\nquery: UPDATE cache_menu SET data = 'a:2:{s:4:\\"tree\\";a:0:{}s:10:\\"node_links\\";a:0:{}}', created = 1242163654, expire = 0, headers = '', serialized = 1 WHERE cid = 'links:primary-links:tree-data:5d6d3aaaaef5fba302ce62698fa37bbe'\";s:5:\"%file\";s:52:\"/home/theherbc/public_html/Howies/includes/cache.inc\";s:5:\"%line\";i:109;}', 3, '', 'https://www.theherbcellar.com/Howies/admin/build/modules', 'https://www.theherbcellar.com/Howies/admin/build/modules', '97.125.165.96', 12421636 in /home/theherbc/public_html/Howies/includes/database.mysqli.inc on line 128

Warning: MySQL server has gone away query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (1, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:12:\"user warning\";s:8:\"%message\";s:286:\"MySQL server has gone away\nquery: UPDATE cache_menu SET data = 'links:primary-links:tree-data:5d6d3aaaaef5fba302ce62698fa37bbe', created = 1242163654, expire = 0, headers = '', serialized = 0 WHERE cid = 'links:primary-links:page-cid:admin/build/modules:1'\";s:5:\"%file\";s:52:\"/home/theherbc/public_html/Howies/includes/cache.inc\";s:5:\"%line\";i:109;}', 3, '', 'https://www.theherbcellar.com/Howies/admin/build/modules', 'https://www.theherbcellar.com/Howies/admin/build/modules', '97.125.165.96', 1242163654) in /home/theherbc/public_html/Howies/includes/database.mysqli.inc on line 128

Warning: MySQL server has gone away query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (1, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:12:\"user warning\";s:8:\"%message\";s:176:\"MySQL server has gone away\nquery: SELECT data, created, headers, expire, serialized FROM cache_menu WHERE cid = 'links:secondary-links:page-cid:admin/build/modules:1'\";s:5:\"%file\";s:52:\"/home/theherbc/public_html/Howies/includes/cache.inc\";s:5:\"%line\";i:26;}', 3, '', 'https://www.theherbcellar.com/Howies/admin/build/modules', 'https://www.theherbcellar.com/Howies/admin/build/modules', '97.125.165.96', 1242163654) in /home/theherbc/public_html/Howies/includes/database.mysqli.inc on line 128

Warning: MySQL server has gone away query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (1, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:12:\"user warning\";s:8:\"%message\";s:184:\"MySQL server has gone away\nquery: SELECT p1, p2, p3, p4, p5, p6, p7, p8 FROM menu_links WHERE menu_name = 'secondary-links' AND link_path IN ('admin/build/modules')\";s:5:\"%file\";s:51:\"/home/theherbc/public_html/Howies/includes/menu.inc\";s:5:\"%line\";i:897;}', 3, '', 'https://www.theherbcellar.com/Howies/admin/build/modules', 'https://www.theherbcellar.com/Howies/admin/build/modules', '97.125.165.96', 1242163654) in /home/theherbc/public_html/Howies/includes/database.mysqli.inc on line 128

Warning: MySQL server has gone away query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (1, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:12:\"user warning\";s:8:\"%message\";s:181:\"MySQL server has gone away\nquery: SELECT p1, p2, p3, p4, p5, p6, p7, p8 FROM menu_links WHERE menu_name = 'secondary-links' AND link_path = 'admin/build/modules'\";s:5:\"%file\";s:51:\"/home/theherbc/public_html/Howies/includes/menu.inc\";s:5:\"%line\";i:902;}', 3, '', 'https://www.theherbcellar.com/Howies/admin/build/modules', 'https://www.theherbcellar.com/Howies/admin/build/modules', '97.125.165.96', 1242163654) in /home/theherbc/public_html/Howies/includes/database.mysqli.inc on line 128

Warning: MySQL server has gone away query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (1, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:12:\"user warning\";s:8:\"%message\";s:485:\"MySQL server has gone away\nquery: \n SELECT m.load_functions, m.to_arg_functions, m.access_callback, m.access_arguments, m.page_callback, m.page_arguments, m.title, m.title_callback, m.title_arguments, m.type, m.description, ml.*\n FROM menu_links ml LEFT JOIN menu_router m ON m.path = ml.router_path\n WHERE ml.menu_name = 'secondary-links' AND ml.plid IN (0)\n ORDER BY p1 ASC, p2 ASC, p3 ASC, p4 ASC, p5 ASC, p6 ASC, p7 ASC, p8 ASC, p9 ASC\";s:5:\"%file\";s:51:\"/home/theherbc/public_html/Howies/includes/menu.inc\";s:5:\"%line\";i:940;}', 3, '', 'https://www.theherbcella in /home/theherbc/public_html/Howies/includes/database.mysqli.inc on line 128

Warning: MySQL server has gone away query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (1, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:12:\"user warning\";s:8:\"%message\";s:188:\"MySQL server has gone away\nquery: SELECT data, created, headers, expire, serialized FROM cache_menu WHERE cid = 'links:secondary-links:tree-data:5d6d3aaaaef5fba302ce62698fa37bbe'\";s:5:\"%file\";s:52:\"/home/theherbc/public_html/Howies/includes/cache.inc\";s:5:\"%line\";i:26;}', 3, '', 'https://www.theherbcellar.com/Howies/admin/build/modules', 'https://www.theherbcellar.com/Howies/admin/build/modules', '97.125.165.96', 1242163654) in /home/theherbc/public_html/Howies/includes/database.mysqli.inc on line 128

Warning: MySQL server has gone away query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (1, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:12:\"user warning\";s:8:\"%message\";s:309:\"MySQL server has gone away\nquery: UPDATE cache_menu SET data = 'a:2:{s:4:\\"tree\\";a:0:{}s:10:\\"node_links\\";a:0:{}}', created = 1242163654, expire = 0, headers = '', serialized = 1 WHERE cid = 'links:secondary-links:tree-data:5d6d3aaaaef5fba302ce62698fa37bbe'\";s:5:\"%file\";s:52:\"/home/theherbc/public_html/Howies/includes/cache.inc\";s:5:\"%line\";i:109;}', 3, '', 'https://www.theherbcellar.com/Howies/admin/build/modules', 'https://www.theherbcellar.com/Howies/admin/build/modules', '97.125.165.96', 124216 in /home/theherbc/public_html/Howies/includes/database.mysqli.inc on line 128

Warning: MySQL server has gone away query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (1, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:12:\"user warning\";s:8:\"%message\";s:290:\"MySQL server has gone away\nquery: UPDATE cache_menu SET data = 'links:secondary-links:tree-data:5d6d3aaaaef5fba302ce62698fa37bbe', created = 1242163654, expire = 0, headers = '', serialized = 0 WHERE cid = 'links:secondary-links:page-cid:admin/build/modules:1'\";s:5:\"%file\";s:52:\"/home/theherbc/public_html/Howies/includes/cache.inc\";s:5:\"%line\";i:109;}', 3, '', 'https://www.theherbcellar.com/Howies/admin/build/modules', 'https://www.theherbcellar.com/Howies/admin/build/modules', '97.125.165.96', 1242163654) in /home/theherbc/public_html/Howies/includes/database.mysqli.inc on line 128

I unchecked the "Discounts" module and error goes away.
When you say disable and uninstall, I know how to disable it, how do you uninstall the module? Deleting the folder?
I did check the database tables after I deleted the folder but the uc_discounts_** where still there. No base table.

Thanks for the quick response,
Z

Comment #5

ryangroe commented 12 May 2009 at 23:07

To uninstall a module first disable it, then on the modules page click the uninstall tab. There you will see the uc_discounts_alt module. Click the box next to it and submit. Verify the tables have been deleted. Then try installing the module again.

Comment #6

Zalatar commented 13 May 2009 at 01:22

Ok Uninstalled per instructions. Tables were deleted. Got following message when uninstalled:

user warning: Unknown table 'uc_discounts' query: DROP TABLE uc_discounts in /home/theherbc/public_html/Howies/includes/database.mysql-common.inc on line 261.

To be expected.

Reinstalled module and got following error:

user warning: Column length too big for column 'description' (max = 255); use BLOB or TEXT instead query: CREATE TABLE uc_discounts ( `discount_id` INT NOT NULL auto_increment, `name` VARCHAR(255) NOT NULL DEFAULT '', `short_description` VARCHAR(100) NOT NULL DEFAULT '', `description` VARCHAR(1000) NOT NULL DEFAULT '', `qualifying_type` INT NOT NULL DEFAULT 0, `qualifying_amount` FLOAT NOT NULL DEFAULT 0, `has_qualifying_amount_max` TINYINT NOT NULL DEFAULT 0, `qualifying_amount_max` FLOAT NOT NULL DEFAULT 0, `discount_type` INT NOT NULL DEFAULT 0, `discount_amount` FLOAT NOT NULL DEFAULT 0, `requires_code` TINYINT NOT NULL DEFAULT 1, `filter_type` INT NOT NULL DEFAULT 1, `has_role_filter` TINYINT NOT NULL DEFAULT 0, `requires_single_product_to_qualify` TINYINT NOT NULL DEFAULT 1, `max_times_applied` INT NOT NULL DEFAULT 1, `can_be_combined_with_other_discounts` TINYINT NOT NULL DEFAULT 0, `max_uses` INT NOT NULL DEFAULT 0, `max_uses_per_user` INT NOT NULL DEFAULT 1, `has_expiration` TINYINT NOT NULL DEFAULT 0, `expiration` INT NOT NULL DEFAULT 0, `is_published` TINYINT DEFAULT 0, `weight` TINYINT NOT NULL DEFAULT 0, `insert_timestamp` INT NOT NULL DEFAULT 0, PRIMARY KEY (discount_id) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in /home/theherbc/public_html/Howies/includes/database.inc on line 515.

Checked tables no uc_discounts table created.

Comment #7

ryangroe commented 13 May 2009 at 03:52

Are you running MySQL 4? If so you will need to make the following change:
In uc_discounts_alt\uc_discounts\uc_discounts.install:
Change:
"length" => 1000,
To
"length" => 255,

Change the max length of descriptions from 1000 to 255.

You will then need to uninstall and reinstall the module.

MySQL 4 is not *officially* supported but I am happy to work with you on any issues you may have.

Comment #8

Zalatar commented 13 May 2009 at 04:41

Cool Beans!!
Made the change and no errors. I will have to set it up tomorrow.

Thank you very much for your support on this issue.
Z

Comment #9

ryangroe commented 13 May 2009 at 04:45

No problem. Let me know how it goes.

Comment #10

ryangroe commented 17 May 2009 at 00:44

Status:

Active

» Closed (fixed)

I am going to mark this closed. Reopen it if you have further problems.

+mysql4

#7 worked for me , MYSQL 4 issue
thanks @ryangroe

Comment #14

kenorb commented 14 April 2011 at 15:22

Status:

Closed (fixed)

» Closed (works as designed)

Missing database table

Comments

Comment #1

Comment #2

Comment #3

Comment #4

Comment #5

Comment #6

Comment #7

Comment #8

Comment #9

Comment #10

Comment #11

Comment #12

Comment #13

Comment #14

News items

Our community

Documentation

Drupal code base

Governance of community