Error on creating new project

  • Resolved smolenaar

    (@smolenaar)


    5 years, 8 months ago

    I get an error message on creating a new project:
    Error: Project id must be entered.

    my config:

    Operating System
    Type=Linux
    Release=3.10.0-957.21.3.el7.x86_64
    Version=#1 SMP Tue Jun 18 16:35:19 UTC 2019
    Machine Type=x86_64
    Host Name=ams1.sebs.space
    Database Management System
    Version=10.3.16-MariaDB
    Pivileges=Alter, Alter routine, Create, Create routine, Create temporary tables, Create view, Create user, Delete, Delete versioning rows, 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 ‘molenaar’@’localhost’ IDENTIFIED BY PASSWORD ‘*****’GRANT ALL PRIVILEGES ON fuel\_wordpress.* TO ‘molenaar’@’localhost’ WITH GRANT OPTIONGRANT ALL PRIVILEGES ON molenaar.* TO ‘molenaar’@’localhost’ WITH GRANT OPTIONGRANT ALL PRIVILEGES ON cloud\_molenaar.* TO ‘molenaar’@’localhost’ WITH GRANT OPTIONGRANT ALL PRIVILEGES ON fuel.* TO ‘molenaar’@’localhost’ WITH GRANT OPTION
    Web Server
    Software=Apache/2.4.6
    PHP Version=7.3.6
    Protocol=HTTP/1.1
    Name=fuel.molenaar.co.uk
    Address=2a03:b0c0:2:d0::df6:4001
    Root DIR=/home/molenaar/domains/fuel.molenaar.co.uk/public_html
    Temp DIR=/tmp
    HTTP Upload=Enabled
    Max Upload File Size=100M
    Post Max Size=105M
    Max Execution Time=40
    Max Input Time=120
    Memory Limit=512M
    Output Buffering=4096
    WordPress
    Version=5.2.2
    Home DIR=/home/molenaar/domains/fuel.molenaar.co.uk/public_html/???>???750
    Uploads DIR=/home/molenaar/domains/fuel.molenaar.co.uk/public_html/wp-content/uploads???>???755
    Home URL=https://fuel.molenaar.co.uk
    Site URL=https://fuel.molenaar.co.uk
    Upload URL=https://fuel.molenaar.co.uk/wp-content/uploads
    Use MySQLi=true
    Database Host=localhost
    Database Name=fuel_wordpress
    Database User=molenaar
    Database Character Set=utf8
    Database Collate=
    WP Debugging Mode=false
    WP Data Access
    Version=2.0.14
    Repository=+wp_wpda_menu_items (InnoDB | latin1_swedish_ci) (triggers +insert | +update) +wp_wpda_table_design (InnoDB | latin1_swedish_ci) +wp_wpda_logging (InnoDB | latin1_swedish_ci) +wp_wpdp_project (InnoDB | latin1_swedish_ci) +wp_wpdp_page (InnoDB | latin1_swedish_ci) +wp_wpdp_table (InnoDB | latin1_swedish_ci)
    Browser
    Agent=Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/75.0.3770.100 Safari/537.36
    Chrome=true
    Version=75.0.3770.100
    Webkit=true

    Going to data explorer and adding data to wpdp_project gives the same error.

Viewing 15 replies - 1 through 15 (of 18 total)
  • Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    Hi S,

    This topic is haunting me! I’ve seen it before. So far I haven’t been able to reproduce it. I might have found a solution however. I just patched the current release. Can you please try to delete the plugin and then install it again from the WordPress plugin directory to see if it works.

    Best regards,
    Peter

    Thread Starter smolenaar

    (@smolenaar)

    Nope sorry.
    I set the uninstall options to delete everything

    uninstalled and reinstalled.

    Same thing, same error on adding menus

    Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    Sorry! Can we try again? I patched the current release again. Maybe this will make the difference…

    If not, I could provide you with a modified version of the WPDA_Simple_Form_Data class file containing some log actions that might give us more information. Do you have access to the file system to overwrite that class file? Unfortunately I can’t reproduce this error on any of my own machines so I’m depending on the cooperation of someone willing to help to solve this issue.

    Best regards,
    Peter

    Thread Starter smolenaar

    (@smolenaar)

    No sorry, still the same.

    It’s my own server, I’ve got access to everything.

    Thread Starter smolenaar

    (@smolenaar)

    Exact same problem on adding menu items by the way

    Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    I think this is some configuration issue, so I guess you’ll have this error for every table that has an auto increment column.

    Today is a very busy day. I’ll see if I can send you a modified class file tonight or tomorrow. I really hope we can solve this problem.

    Thanks for your cooperation and patience.

    Best regards,
    Peter

    Thread Starter smolenaar

    (@smolenaar)

    No problem, this is a hobby project so no rush.

    I noticed some others had the same problem but gave up before getting to the bottom of it.

    Ran a “composer update” in the plugin folder as well, but that didn’t make a difference either

    Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    Hi S,

    I added some debug info to the class which causes the problem (I think…). You can download it from here:
    https://drive.google.com/file/d/1NfI9t7nepIOeVCPN2Tg0zblS5FVnY9PZ/view?usp=sharing

    The file is located here:
    ../plugin/wp-data-access/WPDataAccess/Simple_Form/

    If you try to create a new project again you should get some debug info. I’m very greatly if you can post that info. I hope this gives more insight…

    Thanks a lot!!!

    Best regards,
    Peter

    Thread Starter smolenaar

    (@smolenaar)

    Sorry, there now is a debug button, but it shows a blank screen

    Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    That’s bad news!

    Your System Info shows a version 3 Linux kernel. Looks like others having this issue had the same release. Can you tell me what OS and tools you are using? Maybe I can setup a virtual machine with the exact same OS, DBMS and tools you have to see if I can reproduce this issue.

    Thanks again!

    Best regards,
    Peter

    Thread Starter smolenaar

    (@smolenaar)

    Centos 7.6
    Virtualmin 6.06
    Php 7.3 (remi repo)
    MariaDB 10.3

    DigitalOcean vps

    Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    I’ll download Centos 7.6 and see if I can reproduce this error. I’ll let you know…

    Thanks! ??

    Best regards,
    Peter

    Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    Hi S,

    Yesterday I setup a virtual host with the same configuration as you have. Unfortunately I could not reproduce the problem.

    What is your sql_mode setting? To check this you can perform the following statement on the MySQL command line: (you probably know…)
    SHOW VARIABLES LIKE ‘sql_mode’

    Best regards,
    Peter

    Thread Starter smolenaar

    (@smolenaar)

    STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTI

    Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    Hi S,

    Yes! ?? Finally I was able to reproduce the error! Haunting me for quite some time… I created a droplet on DigitalOcean, installed the same tools and I’m getting the same error now.

    Looks like MariaDB doesn’t process the joins correctly. Is does not accept USING (col1, col2) so I had to rewrite these join conditions. There are some other minor issues as well which I hope to solve asap. Still don’t understand why my local installation worked, but I have a solution now that works on all my installation including Digitalocean VPS.

    I have planned to release a new version by the end of this week or the beginning of next week. Just update and you should be fine. I will leave this topic open and inform you when I’ve released the new version.

    Thank you very much for your cooperation! ??

    Best regards,
    Peter

Viewing 15 replies - 1 through 15 (of 18 total)
  • The topic ‘Error on creating new project’ is closed to new replies.