Ustramator

Amazing! Thank you very much!! There are so many functions, I missed this one.

I would like to add here that if you use a TinyMCE editor plugin, like “Advanced Editor Tools”, you can insert images and get a lot more editing tools.

• This reply was modified 2 years, 1 month ago by Ustramator.

It works great!!!
Now all fields are translatable.
Thank you!!!

I don’t believe I didn’t see it! Thank you so much!
Is there any possibility to resolve the second issue, the translation of the entries in drop down lists? Or am I doing something wrong again? ??

I want to say a very big Thank You to Peter for his support.
My problem with no tables appearing in the list when creating a new Publisher can be resolved by turning temporarily “Mod_Security” to “detection only”. Then, after creating the Publishers, you can revert it to normal. The created Publishers are there and work like a charm.

Hello again Peter. I answered with a message through the form 2 days ago. Did you receive it?

Hello again and thank you for trying to figure out what is happening. It seems that there is an auth problem.
I want to inform you that when I hover over a table name in Explorer, there are 2 options that appear: Manage and Explore. Manage doesn’t work (it only shows “Loading…”), but Explore works, opens the table entries and I can edit and save them.

The response you asked is:
HTTP/2 403 Forbidden
server: nginx
date: Mon, 07 Dec 2020 16:34:40 GMT
content-type: text/html; charset=iso-8859-1
content-length: 220
X-Firefox-Spdy: h2

Here is the full Request and Response:

{
“log”: {
“version”: “1.2”,
“creator”: {
“name”: “Firefox”,
“version”: “83.0”
},
“browser”: {
“name”: “Firefox”,
“version”: “83.0”
},
“pages”: [
{
“startedDateTime”: “2020-12-07T17:26:40.576+02:00”,
“id”: “page_2”,
“title”: “WP Data Access ? **** — WordPress”,
“pageTimings”: {
“onContentLoad”: 2376,
“onLoad”: 2700
}
}
],
“entries”: [
{
“pageref”: “page_2”,
“startedDateTime”: “2020-12-07T17:26:40.576+02:00”,
“request”: {
“bodySize”: 29,
“method”: “POST”,
“url”: “https://*****.info/wp-admin/admin.php?action=wpda_get_tables”,
“httpVersion”: “HTTP/2”,
“headers”: [
{
“name”: “Host”,
“value”: “*****.info”
},
{
“name”: “User-Agent”,
“value”: “Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:83.0) Gecko/20100101 Firefox/83.0”
},
{
“name”: “Accept”,
“value”: “*/*”
},
{
“name”: “Accept-Language”,
“value”: “en-US,en;q=0.5”
},
{
“name”: “Accept-Encoding”,
“value”: “gzip, deflate, br”
},
{
“name”: “Referer”,
“value”: “https://*****.info/wp-admin/admin.php?page=wpda_publisher&table_name=m4uIc67_wpda_publisher”
},
{
“name”: “Content-Type”,
“value”: “application/x-www-form-urlencoded; charset=UTF-8”
},
{
“name”: “X-Requested-With”,
“value”: “XMLHttpRequest”
},
{
“name”: “Content-Length”,
“value”: “29”
},
{
“name”: “Origin”,
“value”: “https://*****.info”
},
{
“name”: “Connection”,
“value”: “keep-alive”
},
{
“name”: “Cookie”,
“value”: “wordpress_sec_0ae5610a1ee8a6d1de92c30710ba74a4=*****%7C1607440780%7CvCYwNZiyzVZq7U8tjxl2cTX4LM7wJbtxfxQgOxxxxxx%7Ceaea9b81a0c611ec093409fad0ee11c029ce3eea58ff219ce4ee86936fxxxxxx; _ga=GA1.2.1176689549.1607267964; wp-settings-1=libraryContent%3Dbrowse%26mfold%3Do%26editor%3Dtinymce%26post_dfw%3Doff%26hidetb%3D1; wp-settings-time-1=1607267994; PHPSESSID=d18e94416e7d525cbd471597c1xxxxxx; wordpress_test_cookie=WP+Cookie+check; wordpress_logged_in_0ae5610a1ee8a6d1de92c30710ba74a4=*****%7C1607440780%7CvCYwNZiyzVZq7U8tjxl2cTX4LM7wJbtxfxQgOxxxxxx%7C6a2c50003bd04b07717ad1db1ff1ba340c0def69ccb2e8cc32da32fcffxxxxxx”
},
{
“name”: “TE”,
“value”: “Trailers”
}
],
“cookies”: [
{
“name”: “wordpress_sec_0ae5610a1ee8a6d1de92cxxxxxxxx”,
“value”: “*****|1607440780|vCYwNZiyzVZq7U8tjxl2cTX4LM7wJxxxxxxxx|eaea9b81a0c611ec093409fad0ee11c029ce3eea58ff219ce4ee86———-”
},
{
“name”: “_ga”,
“value”: “GA1.2.1176689549.1607267964”
},
{
“name”: “wp-settings-1”,
“value”: “libraryContent=browse&mfold=o&editor=tinymce&post_dfw=off&hidetb=1”
},
{
“name”: “wp-settings-time-1”,
“value”: “1607267994”
},
{
“name”: “PHPSESSID”,
“value”: “d18e94416e7d525cbd471597c1xxxxxx”
},
{
“name”: “wordpress_test_cookie”,
“value”: “WP+Cookie+check”
},
{
“name”: “wordpress_logged_in_0ae5610a1ee8a6d1de92cxxxxxxxx”,
“value”: “*****|1607440780|vCYwNZiyzVZq7U8tjxl2cTX4LM7wJxxxxxxxx|6a2c50003bd04b07717ad1db1ff1ba340c0def69ccb2e8cc32da32———-”
}
],
“queryString”: [
{
“name”: “action”,
“value”: “wpda_get_tables”
}
],
“headersSize”: 1194,
“postData”: {
“mimeType”: “application/x-www-form-urlencoded”,
“params”: [
{
“name”: “schema_name”,
“value”: “y102726XXXXXX”
}
],
“text”: “schema_name=y102726XXXXXX”
}
},
“response”: {
“status”: 403,
“statusText”: “Forbidden”,
“httpVersion”: “HTTP/2”,
“headers”: [
{
“name”: “server”,
“value”: “nginx”
},
{
“name”: “date”,
“value”: “Mon, 07 Dec 2020 15:26:41 GMT”
},
{
“name”: “content-type”,
“value”: “text/html; charset=iso-8859-1”
},
{
“name”: “content-length”,
“value”: “220”
},
{
“name”: “X-Firefox-Spdy”,
“value”: “h2”
}
],
“cookies”: [],
“content”: {
“mimeType”: “text/html; charset=iso-8859-1”,
“size”: 220,
“text”: “<!DOCTYPE HTML PUBLIC \”-//IETF//DTD HTML 2.0//EN\”>\n<html><head>\n<title>403 Forbidden</title>\n</head><body>\n<h1>Forbidden</h1>\n<p>You don’t have permission to access /wp-admin/admin.php\non this server.</p>\n</body></html>\n”
},
“redirectURL”: “”,
“headersSize”: 162,
“bodySize”: 382
},
“cache”: {},
“timings”: {
“blocked”: -1,
“dns”: 0,
“connect”: 0,
“ssl”: 0,
“send”: 0,
“wait”: 408,
“receive”: 0
},
“time”: 407,
“_securityState”: “secure”,
“serverIPAddress”: “xxx.xxx.xxx.xxx”,
“connection”: “443”
}
]
}
}

This is the system info from the plugin:

Operating System
Type=Linux
Release=3.10.0-962.3.2.lve1.5.38.el7.x86_64
Version=#1 SMP Thu Jun 18 05:28:41 EDT 2020
Machine Type=x86_64
Host Name=*****
Database Management System
Version=10.2.36-MariaDB
Pivileges=Alter, Alter routine, Create, Create routine, Create temporary tables, Create view, Create user, Delete, Drop, Event, Execute, File, Grant option, Index, Insert, Lock tables, Process, Proxy, References, Reload, Replication client, Replication slave, Select, Show databases, Show view, Shutdown, Super, Trigger, Create tablespace, Update, Usage
Grants=GRANT USAGE ON *.* TO ‘******’@’%’ IDENTIFIED BY PASSWORD ‘*****’GRANT ALL PRIVILEGES ON ***.* TO ‘***’@’%’
SQL Mode=NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
Web Server
Software=Apache
PHP Version=7.2.34
Protocol=HTTP/1.0
Name=***
Address=46.4.69.115
Root DIR=/var/www/vhosts/***.com/***.gr
Temp DIR=/tmp
HTTP Upload=Enabled
Max Upload File Size=64M
Post Max Size=64M
Max Execution Time=180
Max Input Time=180
Memory Limit=384M
Output Buffering=4096
WordPress
Version=5.5.3
Home DIR=/var/www/vhosts/***.com/****.gr/???>???750
Uploads DIR=/var/www/vhosts/***.com/***.gr/wp-content/uploads???>???755
Home URL=https://***.gr
Site URL=https://***.gr
Upload URL=https://***.gr/wp-content/uploads
Use MySQLi=true
Database Host=localhost:3306
Database Name=***
Database User=***
Database Character Set=utf8
Database Collate=
WP Debugging Mode=false
WP Data Access
Version=4.0.1
Repository=+Y8lbq_wpda_menus (InnoDB | utf8_general_ci) +Y8lbq_wpda_table_design (InnoDB | utf8_general_ci) +Y8lbq_wpda_logging (InnoDB | utf8_general_ci) +Y8lbq_wpda_project (InnoDB | utf8_general_ci) +Y8lbq_wpda_project_page (InnoDB | utf8_general_ci) +Y8lbq_wpda_project_table (InnoDB | utf8_general_ci) +Y8lbq_wpda_media (InnoDB | utf8_general_ci) +Y8lbq_wpda_publisher (InnoDB | utf8_general_ci) +Y8lbq_wpda_table_settings (InnoDB | utf8_general_ci)
Browser
Agent=Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_4) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.1 Safari/605.1.15

Yes, I see all tables in Data Explorer. Also, I can create test tables in Designer and added in Repository. I added a photo of Explorer in the above shared album.
I want to add that I installed the plugin on 2 more WP sites I have, with different content (themes, plugins, etc) and it also doesn’t work.

• This reply was modified 3 years, 11 months ago by Ustramator.
• This reply was modified 3 years, 11 months ago by Ustramator.