Elxis CMS Forum

Extensions => Modules => Topic started by: michalis1984 on September 14, 2014, 14:06:46

Title: mod_advertising problem?
Post by: michalis1984 on September 14, 2014, 14:06:46

Is anyone using this module version 1.2?

I use 1.0 on some other sites and it works well. I install 1.2 on new website and when i publish the module i see white page. No website contents, nothing, just white page and the tite of this module, if the setting is to be shown.

Title: Re: mod_advertising problem?
Post by: datahell on September 14, 2014, 18:14:03

White page means PHP fatal error. There is something wrong in the module.
See Elxis logs for the relevant error message and copy-paste it here.

Administration > Site > Logs > Error log

Title: Re: mod_advertising problem?
Post by: michalis1984 on September 14, 2014, 19:53:06

This is what i see at error logs:

Code: [Select]

[2014-09-14 11:03:53] ERROR in file /home/iliada/public_html/iliada/modules/mod_advertising/mod_advertising.php line 215
Call-time pass-by-reference has been removed

[2014-09-14 11:04:07] ERROR in file /home/iliada/public_html/iliada/modules/mod_advertising/mod_advertising.php line 215
Call-time pass-by-reference has been removed


Title: Re: mod_advertising problem?
Post by: datahell on September 14, 2014, 21:54:20

The module is by Acambal, I made a small change. Install the version I attach here.

Title: Re: mod_advertising problem?
Post by: michalis1984 on September 14, 2014, 22:29:39

I install the 1.3 version, again white page. The new error is this:

Quote

[2014-09-14 19:09:19]    ERROR in file /home/iliada/public_html/iliada/includes/libraries/elxis/database/statement.class.php line 41
Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'a.publish_from' in 'where clause'' in /home/iliada/public_html/iliada/includes/libraries/elxis/database/statement.class.php:41
Stack trace:
#0 /home/iliada/public_html/iliada/includes/libraries/elxis/database/statement.class.php(41): PDOStatement->execute(NULL)
#1 /home/iliada/public_html/iliada/modules/mod_advertising/mod_advertising.php(141): elxisPDOStatement->execute()
#2 /home/iliada/public_html/iliada/modules/mod_advertising/mod_advertising.php(508): modAdvertising->run()
#3 /home/iliada/public_html/iliada/includes/libraries/elxis/module.class.php(295): include('/home/iliada/pu...')
#4 /home/iliada/public_html/iliada/includes/libraries/elxis/module.class.php(176): elxisModule->render(Object(stdClass), '', 0)
#5 /home/iliada/public_html/iliada/includes/libraries/elxis/document.class.php(1063): elxisModule->renderPosition('right', '',

Also, i install 1.2 version to other 2 websites, which run again on elxis 4.2. I also get identical error. The error at my first post was only at the first site.

Site 2 with elxis 4.2 and mod_advertising 1.2

Quote

[2014-09-14 16:50:12]    ERROR in file /home/michalis/public_html/usoft/includes/libraries/elxis/database/statement.class.php line 41
Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'a.publish_from' in 'where clause'' in /home/michalis/public_html/usoft/includes/libraries/elxis/database/statement.class.php:41
Stack trace:
#0 /home/michalis/public_html/usoft/includes/libraries/elxis/database/statement.class.php(41): PDOStatement->execute(NULL)
#1 /home/michalis/public_html/usoft/modules/mod_advertising/mod_advertising.php(141): elxisPDOStatement->execute()
#2 /home/michalis/public_html/usoft/modules/mod_advertising/mod_advertising.php(508): modAdvertising->run()
#3 /home/michalis/public_html/usoft/includes/libraries/elxis/module.class.php(295): include('/home/michalis/...')
#4 /home/michalis/public_html/usoft/includes/libraries/elxis/module.class.php(176): elxisModule->render(Object(stdClass), '', 0)
#5 /home/michalis/public_html/usoft/includes/libraries/elxis/document.class.php(1063): elxisModule->render

Site 3 with elxis 4.2 and mod_advertising 1.2

Quote

[2014-09-14 19:16:45]    ERROR in file /home/michalis/public_html/glwss/includes/libraries/elxis/database/statement.class.php line 41
Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'a.publish_from' in 'where clause'' in /home/michalis/public_html/glwss/includes/libraries/elxis/database/statement.class.php:41
Stack trace:
#0 /home/michalis/public_html/glwss/includes/libraries/elxis/database/statement.class.php(41): PDOStatement->execute(NULL)
#1 /home/michalis/public_html/glwss/modules/mod_advertising/mod_advertising.php(141): elxisPDOStatement->execute()
#2 /home/michalis/public_html/glwss/modules/mod_advertising/mod_advertising.php(508): modAdvertising->run()
#3 /home/michalis/public_html/glwss/includes/libraries/elxis/module.class.php(275): include('/home/michalis/...')
#4 /home/michalis/public_html/glwss/includes/libraries/elxis/module.class.php(176): elxisModule->render(Object(stdClass), '', 0)
#5 /home/michalis/public_html/glwss/includes/libraries/elxis/document.class.php(1063): elxisModule->renderPosition('right', '', 0)
#6 /home/michalis/public

I notice the last line at each case it looks corrupted.

At the only website i made it to work was at a website running at elxis 4.1 and module 1.0. I upgrade to elxis 4.2 and still works good at 1.0 version.

Title: Re: mod_advertising problem?
Post by: webgift on September 20, 2014, 17:19:32

Please send a private message to @acampball.

Title: Re: mod_advertising problem?
Post by: acampball on September 22, 2014, 08:20:05

Hi.

please run mySQL script

ALTER TABLE `elx_adv_banners` ADD `publish_from` DATETIME;