artodeto's blog about coding, politics and the world

I am not an heavy user of the nextcloud polls application, so this issue could be an oldie but goldie.

I am working on a nextcloud version 30.0.5.1 and I wanted to create a poll.

First discovery, all polls are gone and I was not able to configure anything Preference section. A tail on the nextcloud.log told me that apps/polls/lib/Controller/PollController.php is producing a unknown config key log entry.

Long story short, this link from the closed issue/3806 pointed me to the right direct.
Logged in as admin, I've opened the settings/admin/polls and disabled and enabled the Enable the poll creation globally option. After that and a page reload as a user, almost all is working fine. There is only one open issue with the "copy link to clipboard" option :-.

So i had to evaluate a migration of an existing application from mysql 5.1 to mysql 5.5. Yes i know, the gap between 5.1 and 5.5 is tremendous but the system was working without any problems for a long time of periode.

After switching a test environment from 5.1 to 5.5 there was one unittest failing. What was so special in that given unittest? For a reason, we needed to execute the native propel method "reload" right after a "save". The test was failing because of an empty value for the "id". The representing database table has a column id with an autoincrement flag. With mysql 5.1, everything is working as expected. The id was available after the reload so everything was fine.

After switching to 5.5, no id was available after calling "save". This leads to the fact that propel was failing by executing the "reload" method. Switching back to mysql 5.1 and the error was gone. After search in usergroups, issuepages i still could not find any matching issue or entry. Finally i presentend my problem on the #propel channel in freenode and got some feedback. One guy had experienced the same error in the past. He could remember that this problem occures while switching to mysql 5.3 or 5.4. Niceguy exptom wrote that goosed him with my report and he will give the problem a debug session try.

On the next day, he quickly responded and presented his results. He (if he is a he and not a she) told me he could takle it down to a missleading schema.xml. The column where the error occures had a missing autoIncrement="true" value. I took a look into my current schema.xml and bam same flaw.

The rest is quite easy. Update schema.xml, rerun propel generation and testing. Everything is now working fine. Thanks to exptom again. I guess the schema.xml would have been one of the last areas i had debugged.

If you are using the native php soap client, just enable the trace mechanims and use the build in methods.

array_push($options, array('trace' => 1)); $myPhpSoapClient = new SoapClient($urlToWSDL, $options);

• SoapClient::__getLastRequestHeaders
• SoapClient::__getLastRequest
• SoapClient::__getLastResponseHeaders
• SoapClient::__getLastResponse

Do you ever had the problem that you have no sound on your windows 7? I have and it was hard to find the problem, since windows is acting so ... well not expected ;-). So you want to adjust the volume and an "here is a problem, let me search on the internat for a solution" windows is popping up. After you opened the service management and take a look at the dependencies, you started all needed service but getting the error 1079 again. What to do? Rightclick on the "windows-audio" entry and open properties ("einstellungen"). Click to tab login ("Anmeldung"), select "this account" option and enter "LocalService" as username and "0000" as password. Click Apply and try to start the service. Now everything should work smoothly. Thanks to windows-7-forum.net to show me the way i have to look.