ohnsu
Forum Replies Created
-
Forum: Plugins
In reply to: [WooCommerce] Can’t update woocommerce databaseHi Mirko,
I don’t know what I did but I was able to solve the problem! I really don’t remember what I did.
Thank you again for providing guidance earlier.
Wishing you a great day.
Mai
Forum: Plugins
In reply to: [WooCommerce] Can’t update woocommerce databaseHi Mirko,
Thank you so much for getting back to me so fast. It took me a while to understand what’s being said at the page your link referred me to. Unfortunately I’m not tech savy and I didn’t manage to get it fixed.
I copied the codes and pasted it into phpmyadmin but I received an error.
I copied this:
CREATE TABLEwp_actionscheduler_actions` (
action_idbigint(20) unsigned NOT NULL AUTO_INCREMENT,
hookvarchar(191) COLLATE utf8mb4_unicode_520_ci NOT NULL,
statusvarchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL,
scheduled_date_gmtdatetime DEFAULT NULL,
scheduled_date_localdatetime DEFAULT NULL,
argsvarchar(191) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
schedulelongtext COLLATE utf8mb4_unicode_520_ci,
group_idbigint(20) unsigned NOT NULL DEFAULT ‘0’,
attemptsint(11) NOT NULL DEFAULT ‘0’,
last_attempt_gmtdatetime DEFAULT NULL,
last_attempt_localdatetime DEFAULT NULL,
claim_idbigint(20) unsigned NOT NULL DEFAULT ‘0’,
extended_argsvarchar(8000) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
PRIMARY KEY (action_id),
KEYhook(hook),
KEYstatus(status),
KEYscheduled_date_gmt(scheduled_date_gmt),
KEYargs(args),
KEYgroup_id(group_id),
KEYlast_attempt_gmt(last_attempt_gmt),
KEYclaim_id(claim_id)
) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci;`into SQL
and received this message:
MySQL said: Documentation
#1046 – No database selected
I tried to look for the database in the code hoping I could refer it to the database that my site is on (not sure if I’m thinking the right thing here), but I couldn’t find any. :’)
Do you perhaps know how I can fix this?
Mai