What is that? cgi-mailer@kundenserver.de

Reply·Subscribe

mrtnPremium

281 posts

For a few days i get some strange emails. They are sent in this html code and from

cgi-mailer@kundenserver.de

Does anyone have an idea about this?

<html>

<body>

<h2 style="margin-top: 0px;">An uncaught exception was thrown</h2>

<h3>Details</h3>

<tr>

<td>PDOException</td>

</tr>

<tr>

<td style="font-weight: bold;">Message</td>

<td>SQLSTATE[42S22]: Column not found: 1054 Unknown column 'Date' in 'field list'</td>

</tr>

<tr>

<td>/homepages/40/xxxxxxxxx/htdocs/inc/classes/BxDolDb.php</td>

</tr>

<tr>

</tr>

</table>

<h3>Trace</h3>

<code>

#0 /homepages/40/xxxxxxxxx/htdocs/inc/classes/BxDolDb.php(169): PDO->query('SELECT `id`, `u...')<br />

#1 /homepages/40/xxxxxxxxx/htdocs/inc/classes/BxDolDb.php(212): BxDolDb->res('SELECT `id`, `u...', Array)<br />

#2 /homepages/40/xxxxxxxxx/htdocs/inc/classes/BxDolSiteMapsQuery.php(40): BxDolDb->getAll('SELECT `id`, `u...')<br />

#3 /homepages/40/xxxxxxxxx/htdocs/inc/classes/BxDolSiteMaps.php(289): BxDolSiteMapsQuery->getRecords(Array, 0, 20000)<br />

#4 /homepages/40/xxxxxxxxx/htdocs/inc/classes/BxDolSiteMaps.php(185): BxDolSiteMaps->_getRecords(0)<br />

#5 /homepages/40/xxxxxxxxx/htdocs/inc/classes/BxDolSiteMaps.php(109): BxDolSiteMaps->generate()<br />

#6 /homepages/40/xxxxxxxxx/htdocs/periodic/cron.php(120) : eval()'d code(2): BxDolSiteMaps::generateAllSiteMaps()<br />

#7 /homepages/40/xxxxxxxxx/htdocs/periodic/cron.php(120): eval()<br />

#8 /homepages/40/xxxxxxxxx/htdocs/periodic/cron.php(133): runJob(Array)<br />

#9 {main} </code>

</div>

</body>

</html>

Quote · 20 May 2020

LeonidSGunner

1251 posts

Hello mrtn!

It's necessary to see what query has generated this error. Seems it was hidden in that line PDO->query('SELECT `id`, `u...')

Quote · 21 May 2020

geek_girlPremium

11493 posts

kundenserver.de is 1and1 which is now IONOS; are you hosting with them?

Geeks, making the world a better place

Quote · 22 May 2020

mrtnPremium

281 posts

yes, so it is mail from them .... but why?

Quote · 23 May 2020

geek_girlPremium

11493 posts

It isn't from them per se. It is an error report and it is coming from the server to you reporting that

"An uncaught exception was thrown" with the error: "SQLSTATE[42S22]: Column not found: 1054 Unknown column 'Date' in 'field list'"

So you are getting a database error report from your Dolphin site. Sort of hard to read in that html; emails should have never supported html; it is one reason that viruses have traveled around the net so easily.

Geeks, making the world a better place

Quote · 23 May 2020

mrtnPremium

281 posts

The error has something to do with the generating of the sitemap

An uncaught exception was thrown

Details

TypePDOException

MessageSQLSTATE[42S22]: Column not found: 1054 Unknown column 'Date' in 'field list'

File/homepages/xxxxxxxxxx/htdocs/inc/classes/BxDolDb.php

Line169

Trace

#0 /homepages/xxxxxxxxxx/htdocs/inc/classes/BxDolDb.php(169): PDO->query('SELECT `id`, `u...')

#1 /homepages/xxxxxxxxxx/htdocs/inc/classes/BxDolDb.php(212): BxDolDb->res('SELECT `id`, `u...', Array)

#2 /homepages/xxxxxxxxxx/htdocs/inc/classes/BxDolSiteMapsQuery.php(40): BxDolDb->getAll('SELECT `id`, `u...')

#3 /homepages/xxxxxxxxxx/htdocs/inc/classes/BxDolSiteMaps.php(289): BxDolSiteMapsQuery->getRecords(Array, 0, 20000)

#4 /homepages/xxxxxxxxxx/htdocs/inc/classes/BxDolSiteMaps.php(185): BxDolSiteMaps->_getRecords(0)

#5 /homepages/xxxxxxxxxx/htdocs/inc/classes/BxDolSiteMaps.php(109): BxDolSiteMaps->generate()

#6 /homepages/xxxxxxxxxx/htdocs/administration/sitemap.php(63): BxDolSiteMaps::generateAllSiteMaps()

#7 {main}

When i click "submit" in the TOOLS section, SITEMAP.

Then the error is shown.

Quote · 26 May 2020

geek_girlPremium

11493 posts

Unknown column 'Date' in 'field list'

Yes, what it is saying is that there should be a column in the database table with the heading "Date" and that column is missing. Why is it missing is the question. You can try reinstalling the module.

Geeks, making the world a better place

Quote · 26 May 2020

mrtnPremium

281 posts

I am too clumsy. Which module? As far as i know (and that is not much) sitemap is an internal function of boonex and not a module i can install or uninstall, am i wrong?

Quote · 27 May 2020

geek_girlPremium

11493 posts

You are correct; site map is in tools. OK, the date column is not in the site maps table. It must be about something else.

Here is the sql for the site maps table from the install sql file:

CREATE TABLE IF NOT EXISTS `sys_objects_site_maps` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`object` varchar(32) NOT NULL,
`title` varchar(255) NOT NULL,
`priority` varchar(5) NOT NULL DEFAULT '0.6',
`changefreq` enum('always','hourly','daily','weekly','monthly','yearly','never','auto') NOT NULL DEFAULT 'auto',
`class_name` varchar(255) NOT NULL,
`class_file` varchar(255) NOT NULL,
`order` tinyint(4) NOT NULL,
`active` tinyint(4) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `object` (`object`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

Geeks, making the world a better place

Quote · 28 May 2020

Reply ›

What is that? cgi-mailer@kundenserver.de

Blogs

Help

Product

Company