https://bugs.winehq.org/show_bug.cgi?id=47963
Bug ID: 47963 Summary: Error when submitting a new application to the AppDB Product: WineHQ Apps Database Version: unspecified Hardware: x86 OS: Linux Status: NEW Severity: normal Priority: P2 Component: appdb-unknown Assignee: wine-bugs@winehq.org Reporter: dimesio@earthlink.net Distribution: ---
I assume this is related to the recent upgrade to PHP7.
When trying to submit a new application to the AppDB, it errors out with this message:
Ooops! Something has gone terribly wrong! Our monkey train has derailed! Worry not, a webmaster gopher help army has been dispatched and is on the way.
If this error continues to be a problem, please report it to us on our Forums
error details: Error Message: Database Error: Incorrect integer value: '' for column `apidb`.`appMaintainers`.`versionId` at row 1 Comment:
File: query.php:149
The application entry is created, but it is missing the version information and test results. https://appdb.winehq.org/objectManager.php?sClass=application&iId=19597 is an example.
A couple of forum users have reported a similar error when submitting a new version. https://forum.winehq.org/viewtopic.php?f=11&t=33007
https://bugs.winehq.org/show_bug.cgi?id=47963
Rosanne DiMesio dimesio@earthlink.net changed:
What |Removed |Added ---------------------------------------------------------------------------- CC| |jnewman@codeweavers.com
https://bugs.winehq.org/show_bug.cgi?id=47963
Rosanne DiMesio dimesio@earthlink.net changed:
What |Removed |Added ---------------------------------------------------------------------------- Summary|Error when submitting a new |Error when submitting |application to the AppDB |anything to the AppDB Severity|normal |major
--- Comment #1 from Rosanne DiMesio dimesio@earthlink.net --- There's another report on the forum about a similar error occurring when trying to submit notes and comments. https://forum.winehq.org/viewtopic.php?f=11&t=33097
Revising the summary to reflect the broader nature of the problem and upping the severity.
https://bugs.winehq.org/show_bug.cgi?id=47963
Robert Walker bob.mt.wya@gmail.com changed:
What |Removed |Added ---------------------------------------------------------------------------- CC| |bob.mt.wya@gmail.com
https://bugs.winehq.org/show_bug.cgi?id=47963
Jeremy Newman jnewman@codeweavers.com changed:
What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |NEEDINFO
--- Comment #2 from Jeremy Newman jnewman@codeweavers.com --- MariaDB has a setting that is probably the problem. See here: https://stackoverflow.com/questions/28606483/how-to-allow-empty-string-for-i...
I have globally set sql_mode="" in our DB config. Please retest, and let me know if it is better now.
https://bugs.winehq.org/show_bug.cgi?id=47963
Rosanne DiMesio dimesio@earthlink.net changed:
What |Removed |Added ---------------------------------------------------------------------------- Status|NEEDINFO |RESOLVED Resolution|--- |FIXED
--- Comment #3 from Rosanne DiMesio dimesio@earthlink.net --- I tested adding an application, a note, and a comment, and the problem seems to be fixed. Thanks!
https://bugs.winehq.org/show_bug.cgi?id=47963
--- Comment #4 from Robert Walker bob.mt.wya@gmail.com --- ditto... Working for me as well now... Thanks Jeremy!
https://bugs.winehq.org/show_bug.cgi?id=47963
Ken Sharp imwellcushtymelike@gmail.com changed:
What |Removed |Added ---------------------------------------------------------------------------- Status|RESOLVED |CLOSED
--- Comment #5 from Ken Sharp imwellcushtymelike@gmail.com --- Closing