mikebian

Peter: Awesome! That fixed the problem. Thanks!

So was the issue with the PK being a timestamp? I used to be pretty good with IBM DB2 and I’d do that all the time – meaning no ID type column. It’s great that this worked, and I really don’t care about adding the ID column, but still not sure why it was failing (not that it really matters) and if I was doing something questionable from a MySql point of view with my table def.

Dave: BlueHost does let you create unique db users and assign them to individual databases. What it does not allow you to control is what user gets used when you launch phpMyAdmin from their control panel. It always uses some internal user that it generates and I have no control over.

And I can edit those rows in phpMyAdmin just fine. I was trying to use your plugin to avoid having to go into phpMyAdmin to update them. But, with the way BlueHost works, a different user is used when you go into phpMyAdmin than what WP uses and you have no way of controlling that.

WordPress v 5.3.2

WP Data Access 3.0.2

MySQL: Server version: 5.6.41-84.1 – Percona Server (GPL), Release 84.1, Revision b308619
Protocol version: 10

PHP version: 7.3 (ea-php73)

So, I just tried inserting a row. That worked fine. Then I tried editing it and got the error. Then I tried deleting it, and that worked fine.

View works fine.

When I click edit, the edit page comes up. I then either make a change or just leave it alone, makes no difference. When I click “Save Changes To Database”, I get the error message.

Thanks again!

Table access is set to “Show WordPress Tables”. Everything else was checked except “no content wrap” and debug.

I turned debug on and tried to edit the table again thinking I would get more info somewhere, but didn’t see anything. I checked the PHP log also. What does that actually do?

Here are the table defs:

—
— Create table {wp_prefix}AIT_Registrations
—
CREATE TABLE {wp_prefix}AIT_Registrations (
RegTS timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
CapName varchar(100) NOT NULL,
CapEmail varchar(100) NOT NULL,
CapPhone varchar(100) NOT NULL,
StkName varchar(100) NOT NULL,
StkEmail varchar(100) DEFAULT NULL,
StkPhone varchar(100) DEFAULT NULL,
Addr varchar(100) NOT NULL,
City varchar(50) NOT NULL,
State varchar(50) NOT NULL,
Zip varchar(10) NOT NULL,
Country varchar(20) NOT NULL,
Trip varchar(100) NOT NULL,
EmergContact varchar(100) NOT NULL,
EmergPhone varchar(50) NOT NULL,
Cancelled char(1) DEFAULT NULL,
TripStartDate date NOT NULL,
PRIMARY KEY (RegTS) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

—
— Create table {wp_prefix}AIT_Trips
—
CREATE TABLE {wp_prefix}AIT_Trips (
id mediumint(9) NOT NULL AUTO_INCREMENT,
trip varchar(200) NOT NULL,
startDate date NOT NULL,
endDate date NOT NULL,
URL varchar(200) NOT NULL,
status char(1) NOT NULL,
spotsLeft int(11) NOT NULL DEFAULT ‘0’,
PRIMARY KEY (id),
UNIQUE KEY trip (trip,startDate),
KEY trip_2 (trip,startDate)
) ENGINE=MyISAM AUTO_INCREMENT=34 DEFAULT CHARSET=latin1;

I was able to do the export but I can not send you all the data. The registrations contain my customer database and that has the private data of all my customers. I removed those insert statements from the file, and I can send you the table defs and data from the trips table. Not sure how to send it to you though.

I was able to update and save a row in the ‘WP_OPTIONS’ table.

The tables are ‘wp_AIT_Trips’, which works fine, and ‘wp_AIT_Registrations’, which gives the “ERROR: Not authorized” message. No special characters.

Thanks for the quick reply!

Yup. That clarifies it perfectly. Thanks for the quick response. And thanks for the plugin. That’s a pretty awesome bit of code!

I solved it by uninstalling it and switching to Yoast. Probably not what you wanted to hear.

Yup, that did it!

Thanks

Changed it in both the root and /wp directories. Made no difference. Thanks for replying though.

Sorry, knew I was making that explanation too complex. I am using the AWPCP plugin for the ads and it’s way too complex to be messing with. Besides, I want to keep getting their updates.

The PostSMTP log has exactly what I need, it’s just interspersed with other emails and I just have to carefully copy/paste the email addresses I need. If PostSMTP wrote logs into the database, this would be a snap as a simple SQL query would filter just what I want.

I don’t want to modify PostSMTP. I want to create a new page with some PHP that just accesses the PostSMTP log and filters/displays the data I need. I like a decent programming challenge as that’s how I’ll learn PHP better, but I’m not even sure where to start on this, or if it’s even possible.

Thanks

I am using the Travilify theme, but I don’t see how this is theme related.

In constructing a menu, one can add pages, posts, links and categories as menu items. I am asking for the ability to add another menu as a menu item. This is generic functionality, not specific to a theme, isn’t it?

Thanks

Fortunately I was able to use WP Rollback to move back to 4.9.3, so my site is OK for now. WordPress does not make it easy to run a development site. I will never understand why it insists on fully qualifying internal links. Please don’t try to address that here. Let’s keep this thread on my original problem.

I did some googling on this issue before I posted this question and could not find anyone with the same problem.