Error message when creating a new Project

  • Resolved gglaudje

    (@gglaudje)


    7 years, 1 month ago

    I cannot create a new Data Project. An error message appears stating that a Project Id must be entered. How can I solve this?

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

    (@peterschulznl)

    7 years, 1 month ago

    Hi G,

    Which version of WP Data Access are you using? Make sure you have version 2.0.11 installed. There have been quite a number of bug fixes from 2.0.10 to 2.0.11 in this area.

    If you are using the latest release, can you provide a screenshot?

    Best regards,
    Peter

    Thread Starter gglaudje

    (@gglaudje)

    7 years, 1 month ago

    Hi Peter,

    Thanks for your quick answer.
    I use version 2.0.11 on a local server to test things out.

    A screenshot you can find here!

    I hope you can help me, because I like this plugin very much.

    Best regards,
    Gérard

    • This reply was modified 7 years, 1 month ago by gglaudje. Reason: I made an typing error
    • This reply was modified 7 years, 1 month ago by gglaudje.
    Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    7 years, 1 month ago

    Hi Gerard,

    The ID should be added automatically on insert. Strange it doesn’t. There are NULL values added to empty columns which should not happen as well.

    Some suggestion…

    1) Is you repository valid? To check this, click on menu item “Manage Plugin” and navigate to tab “Manage Repository”. Just click recreate if you are missing the project table.

    2) Can you add a row from the Data Explorer? To test this, navigate to the Data Explorer, search for wpdp_page. Click on Explorer and try to add a new row.

    3) Which web server and database management system are you using?

    4) Have you tried to delete the plugin and reinstall it? Your plugin tables will be dropped and recreated. It might solve your problem.

    Can you give this a try? If nothing works I can send you a copy of the next release that might help us forward…

    Best regards,
    Peter

    Thread Starter gglaudje

    (@gglaudje)

    7 years, 1 month ago

    Hi Peter,

    Thanks for your suggestions. I researched all your tips and here are the results:

    1) The repository is valid! The projecttable is present.

    2) I can’t add a row from the Data Explorer to the table wpdp_page. It gives the same error as adding a project!

    3) The server that I use is Apache HTTP-server 2.4 with PHP 7.2 and managementsystem MariaDB 10

    4) I have deleted the plugin and reinstalled it. It has not solved my problem.

    Hopefully there is an other sollution.

    Best Regards,
    Gerard

    • This reply was modified 7 years, 1 month ago by gglaudje.
    Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    7 years, 1 month ago

    Hi Gerard,

    Sorry, that’s bad news! Looks like a data problem. I suspect it might be the table character set or collation.

    Can you copy the create table script from the Data Explorer to your clipboard and then paste it into a post? To do this, navigate to the Data Explorer, search for wpdp_page, click on Manage, click tab SQL and click on button Copy to clipboard.

    Best regards,
    Peter

    Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    7 years, 1 month ago

    Sorry Gerard, I suggested to search for table wpdp_page but you have to look for table wpdp_project…

    Best regards,
    Peter

    Thread Starter gglaudje

    (@gglaudje)

    7 years, 1 month ago

    Hi Peter,

    Here is a copy of the table script WPDP_PROJECT

    CREATE TABLE wp_wpdp_project (
    project_id mediumint(9) NOT NULL AUTO_INCREMENT,
    project_name varchar(100) COLLATE utf8_unicode_ci NOT NULL,
    project_description text COLLATE utf8_unicode_ci DEFAULT NULL,
    add_to_menu enum(‘Yes’,’No’) COLLATE utf8_unicode_ci DEFAULT NULL,
    menu_name varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
    project_sequence smallint(6) DEFAULT NULL,
    PRIMARY KEY (project_id),
    UNIQUE KEY wp_wpdp_project_project_name (project_name)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci

    Hopefully it helps you to find a sollution.

    Best regards,
    Gerard

    Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    7 years, 1 month ago

    Hi Gerard,

    I dropped my project table, recreated it using your script and it works for me. You could try to drop your project table and recreate it using my script:

    CREATE TABLE wp_wpdp_project (
    project_id mediumint(9) NOT NULL AUTO_INCREMENT,
    project_name varchar(100) NOT NULL,
    project_description text,
    add_to_menu enum(‘Yes’,’No’) DEFAULT NULL,
    menu_name varchar(30) DEFAULT NULL,
    project_sequence smallint(6) DEFAULT NULL,
    PRIMARY KEY (project_id),
    UNIQUE KEY wp_wpdp_project_project_name (project_name)
    ) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=latin1;

    Can you edit any table through the Data Explorer? Or do they all fail?

    You can use the link below to download the current development version which is not yet available in the plugin directory. This version contains a system info page which you can use to send me your configuration. It might help…

    https://drive.google.com/file/d/13e4NcEowzoYf4icaCMvWfpQ3zi7j8LEE/view?usp=sharing

    You can find the system info page in the Manage Plugin menu.

    Best regards,
    Peter

    Thread Starter gglaudje

    (@gglaudje)

    7 years, 1 month ago

    Hi Peter,

    Sorry, but nothing helped.

    Here is my configuration:

    Operating System
    Type=Linux
    Release=3.2.40
    Version=#23824 Tue Feb 12 16:48:52 CST 2019
    Machine Type=armv7l
    Host Name=NASGG
    Database Management System
    Version=10.3.7-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 ‘museumsl’@’localhost’ IDENTIFIED BY PASSWORD ‘*****’GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, REFERENCES, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, EVENT, TRIGGER ON museumsl_wp1.* TO ‘museumsl’@’localhost’
    Web Server
    Software=Apache/2.2.34 (Unix) mod_fastcgi/mod_fastcgi-SNAP-0910052141
    Protocol=HTTP/1.1
    Name=192.168.178.13
    Address=192.168.178.13
    Root DIR=/var/services/web
    HTTP Upload=Enabled
    Max Upload File Size=32M
    Memory Limit=256M
    Output Buffering=4096
    WordPress
    Version=4.9.8
    Home DIR=/volume1/web/wordpress/   >   755
    Uploads DIR=/volume1/web/wordpress/wp-content/uploads   >   755
    Home URL=http://192.168.178.13/wordpress
    Site URL=http://192.168.178.13/wordpress
    Upload URL=http://192.168.178.13/wordpress/wp-content/uploads
    Use MySQLi=true
    Database Host=localhost:/run/mysqld/mysqld10.sock
    Database Name=museumsl_wp1
    Database User=museumsl
    Database Character Set=utf8
    Database Collate=
    WP Debugging Mode=false
    WP Data Access
    Version=2.0.11
    Repository=+wp_wpda_menu_items (InnoDB|utf8_unicode_ci) (triggers +insert | +update) +wp_wpda_table_design (InnoDB|utf8_unicode_ci) +wp_wpda_logging (InnoDB|utf8_unicode_ci) +wp_wpdp_project (InnoDB|utf8_unicode_ci) +wp_wpdp_page (InnoDB|utf8_unicode_ci) +wp_wpdp_table (InnoDB|utf8_unicode_ci)
    Browser
    Agent=Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.131 Safari/537.36
    Chrome=true
    Version=74.0.3729.131
    Webkit=true

    Thanks for all your time

    Best regards

    Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    7 years, 1 month ago

    Hi Gerdard,

    Thanks you for posting your configuration! Unfortunately I have no clue so far. Can you update any table from a Data Explorer data entry page? Or do they all fail?

    Best regards,
    Peter

    Thread Starter gglaudje

    (@gglaudje)

    7 years, 1 month ago

    Hi Peter,

    I can’t update any table at all. They all give the same error message.

    In any case, thanks for your help.

    Best regards,
    Gerard

    Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    7 years, 1 month ago

    Hi Gerard,

    That’s bad news! I presume it is some configuration issue.

    I’m very aeger to solve this problem but I can’t do it without you as for me this works. Regarding your screenshot I guess your Dutch (like me)? 🙂 If you’re intested in solving this problem together you could send me a connection request on LinkedIn to get in touch. You can find me through the link in the plugin. Hope to see you on LinkedIn…

    Best regards,
    Peter

    Thread Starter gglaudje

    (@gglaudje)

    7 years, 1 month ago

    Hello Peter,

    Yes, you guessed correctly, I am a Dutch!

    I have now also installed your plugin on a different server and there it works very good. So the problems are therefore caused by the local server.
    I have already taken too much time from you, so I suggest that we do not look further for a possible cause.
    As far as I’m concerned you can close this item.
    Anyway, thank you for the time you have invested in this.

    With best regards,
    Gerard

    Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    7 years, 1 month ago

    Hi Gerard,

    That’s good news! Although I’m still curious why your first installation didn’t work… 🙂

    I’ll close this topic. Should you find a clue however, I would be greatful if you would share it on the forum.

    Best regards,
    Peter

Viewing 14 replies - 1 through 14 (of 14 total)

The topic ‘Error message when creating a new Project’ is closed to new replies.

Tags