slabbi / uddeIM

udde Instant Messages (uddeIM) - Instant Messages System for Mambo and Joomla
12 stars 9 forks source link

Autoresponder has a problem #100

Closed jojo12 closed 5 months ago

jojo12 commented 5 months ago

When a user chooses the autoresponder, he can send PMs. But when someone else tries to send, reply a PMs, there is an error instead of a message.

jojo12 commented 5 months ago

error: 1136 Column count doesn't match value count at row 1

jojo12 commented 5 months ago
1 () JROOT/libraries/vendor/joomla/database/src/Mysqli/MysqliStatement.php:138
2 mysqli->prepare() JROOT/libraries/vendor/joomla/database/src/Mysqli/MysqliStatement.php:138
3 Joomla\Database\Mysqli\MysqliStatement->__construct() JROOT/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:1020
4 Joomla\Database\Mysqli\MysqliDriver->prepareStatement() JROOT/libraries/vendor/joomla/database/src/DatabaseDriver.php:1785
5 Joomla\Database\DatabaseDriver->setQuery() JROOT/components/com_uddeim/uddeim.php:1253
6 uddeIMsaveMessage() JROOT/components/com_uddeim/uddeim.php:608
7 require_once() JROOT/libraries/src/Dispatcher/LegacyComponentDispatcher.php:71
8 Joomla\CMS\Dispatcher\LegacyComponentDispatcher::Joomla\CMS\Dispatcher{closure}() JROOT/libraries/src/Dispatcher/LegacyComponentDispatcher.php:73
9 Joomla\CMS\Dispatcher\LegacyComponentDispatcher->dispatch() JROOT/libraries/src/Component/ComponentHelper.php:361
10 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:218
11 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:261
12 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:306
13 Joomla\CMS\Application\CMSApplication->execute() JROOT/includes/app.php:58
14 require_once() JROOT/index.php:32
slabbi commented 5 months ago

"That error message typically means the number of values provided in the INSERT statement is bigger or smaller than the number of columns the table has, while at the same time, you did not specify the columns to be inserted. So MySQL doesn’t know which data to insert in which column and it throws back the error."

Bei cryptmode==3 ist der "crypthash" zu viel bzw. es müsste ein leeres Feld eingefügt werden.

slabbi commented 5 months ago

Zeile 1242 von uddeim.php:

Aus
".$savedatum.", 3)";
mach
".$savedatum.", 3, '')";
joomod commented 5 months ago

danke, ich hätte jetzt einfach crypthash weggelassen

uddeim.zip

joomod commented 5 months ago

soll ich das im main ändern oder nachst du das?

(das ist/war aber scheinbar ein uralt Fehler :)

jojo12 commented 5 months ago

ich habs getestet: ich kriege eine Abwesenheitsmeldung-->super gelöst

jojo12 commented 5 months ago

can be closed!