Upgrade error

Permalink Browser Info Environment
Hi, the recent upgrade reported an error. I'm not currently using the addon on my site but letting you know about the error. Error shows immediately after running the upgrade:

mysqli error: [1075: Incorrect table definition; there can be only one auto column and it must be defined as a key] in EXECUTE("ALTER TABLE JbThumbsUpItems ADD id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT")

Type: Discussion
Status: In Progress
designserve
View Replies:
jb1 replied on at Permalink Reply
jb1
Thanks for letting me know.

I had to change one of the table fields from "id" to "itemID" (for better support on different types of servers). So when C5 runs the db "upgrade" it doesn't delete the "old" field - rather it just adds the new one, which is what causes this particular error.

Since the add-on is not being used on your site, the simplest solution is to do an uninstall, delete any MySQL db tables left over (if they are), and then install it from scratch.

Otherwise, to keep the existing data, it would require manually deleting the old "id" field, then running the C5 upgrade after that.

Let me know if that helps.
designserve replied on at Permalink Reply
designserve
Thanks I'll try that on the weekend and get back to you to let you know how it goes.

concrete5 Environment Information

# concrete5 Version
5.6.3.4

# concrete5 Packages
Add Multiple Pages (2.1.1), Advanced Page List (1.0.3), AJAX Member Directory (1.0.1), Backup Voodoo (2.3.5.3), Black Knight (1.2.7), Black Magic Data (1.7), Blocks by AJAX (2.3.0.5), Bookmarks (1.1.4), Bootstrap (3.1.1.4), Cache Free Content (1.1.0.5.6.3.4), Dashboard Maximizer (2.0.4), Discussion (1.8.8), Easy Countdown (1.0.1), Easy Tables (2.0.1), eCommerce (2.8.17), Extreme Clean (1.0), File List Pro (1.3), File With Description (1.1), FlexSlider (2.2.0.5), Front End Filemanager (1.1), Front End File Uploader (2.2.2), HTML5 Audio Player Basic (1.1.6), HTML5 Audio Player Pro (1.3.0.2), Iframe (1.0), Instant CSS (1.1), Lerteco Membership (2.2.2.1), Login (1.1.1), Magic Data (2.10.7), Magic Data Forms (1.2.4), Magic Data Symbols1 (2.7.13), Magic Data Templates1 (2.2), Magic Heading (1.3.1), Magic Job (1.2), Magic Tipple (1.6), Mailing List (2.54), Mp4 Player (1.2), Multiple Domains (1.4.9), Multiple Domains Debug (0.1), Multiple Flat Shipping Rates (1.0.2), Next & Previous (1.02), Paypal Cart System Pro (1.1), Paypal Donations Box (1.0.1), Popup Login (1.0.5), Pro Blog (12.4.4), Pro Media (7.5.0), QuizMaker (1.3), Rigid Light - Theme (2.1), Sapphire (1.5.0), Simply Clean - Theme (2.1), Sisimizi's Download Folder (1.0), Site Notifications (1.0.1), Slate Theme (1.5.3.1), Sortable Fancybox Gallery (1.17), Thumbs Up (1.4.2), tnSpacer (1.3), Toolbar Quick Links (1.2.0.1), Uber List (1.10.1), Universal Content Puller (1.4.7), Universal Content Puller Sources1 (1.4.2), Up Down Vote Lister (1.2.7), User Info (1.97), ViewPort (1.0), Whitespace Theme (1.2), Zoom Image (1.0.5).

# concrete5 Overrides
blocks/content, blocks/discussion_guestbook, blocks/discussion_post_list, blocks/login, blocks/multiple_domains_autonav, blocks/next_previous, blocks/problog_list, blocks/user_badges, controllers/single_pages, controllers/registera.php, elements/tracking.php, helpers/spellchecker.php, helpers/Anavigation.php, helpers/navigation.php, css/discussion.css, libraries/page_cache, libraries/request.php, single_pages/login.php, single_pages/page_not_found.php, single_pages/register.php, single_pages/maintenance_mode.php, single_pages/profile, themes/slate_custom, themes/slate_multiple, themes/slate_technics, themes/viewport_custom, themes/whitespace_custom, themes/slate_custom_black, themes/slate_KN7000, themes/slate_123top

# concrete5 Cache Settings
Block Cache - On
Overrides Cache - Off
Full Page Caching - On - If blocks on the particular page allow it.
Full Page Cache Lifetime - Only when manually removed or the cache is cleared.

# Server Software
Apache

# Server API
cgi-fcgi

# PHP Version
5.4.45

# PHP Extensions
bcmath, bz2, calendar, cgi-fcgi, Core, ctype, curl, date, dba, dom, ereg, exif, fileinfo, filter, ftp, gd, gettext, hash, iconv, imap, intl, ionCube Loader, json, libxml, mbstring, mcrypt, mysql, mysqli, mysqlnd, openssl, pcre, PDO, pdo_mysql, pdo_sqlite, Phar, posix, Reflection, session, shmop, SimpleXML, soap, SPL, SQLite, sqlite3, standard, tidy, tokenizer, wddx, xml, xmlreader, xmlwriter, xsl, zip, zlib.

# PHP Settings
max_execution_time - 30
log_errors_max_len - 1024
max_file_uploads - 20
max_input_nesting_level - 64
max_input_time - -1
max_input_vars - 1000
memory_limit - 128M
post_max_size - 8M
sql.safe_mode - Off
upload_max_filesize - 2M
mysql.max_links - Unlimited
mysql.max_persistent - Unlimited
mysqli.max_links - Unlimited
mysqli.max_persistent - Unlimited
pcre.backtrack_limit - 1000000
pcre.recursion_limit - 100000
session.cache_limiter - nocache
session.gc_maxlifetime - 7200
soap.wsdl_cache_limit - 5

Browser User-Agent String

Mozilla/5.0 (Windows NT 6.3; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/48.0.2564.116 Safari/537.36

Hide Post Content

This will replace the post content with the message: "Content has been removed by an Administrator"

Hide Content

Request Refund

You may not request a refund that is not currently owned by you.