Gossamer Forum
Home : Products : Gossamer Mail : Discussion :

bug: simple template error

Quote Reply
bug: simple template error
when members login using simple temlate thye get this error:
A fatal error has occured:

DBD::mysql::st execute failed: You have an error in your SQL syntax near 'WHERE userid = '3'' at line 1 at /home/httpd/cgi-bin/bareedna/admin/GT/SQL/Driver/MYSQL.pm line 68.

Please enable debugging in setup for more details.


i did upgrade to 2.02 but i kept the old template which i do not think gm changed it

Quote Reply
Re: bug: simple template error In reply to
if there is no solution to this. could someone tell me how can i remove the simple template from the script so users do not have this option

Quote Reply
Re: bug: simple template error In reply to
You just remove the simple template folder from the templates directory.

The last time I did this though there were some hard-coded links to the simple templates - I believe Scott fixed these up though so there should be no problem doing it.

You'll also have to make sure you've got another template set set to be the default in the admin area.

Cheers,
R.


Quote Reply
Re: bug: simple template error In reply to
Hi,

If you are still seeing this, can you turn on debug mode, and send me the full output?

Cheers,

Alex

--
Gossamer Threads Inc.
Quote Reply
Re: bug: simple template error In reply to
i'm still getting the same error here is what i get:

A fatal error has occured:

DBD::mysql::st execute failed: You have an error in your SQL syntax near 'WHERE userid = '2'' at line 1 at /home/httpd/cgi-bin/bareedna/admin/GT/SQL/Driver/MYSQL.pm line 68.


Stack Trace
======================================
GMail (16649): GT::SQL::Driver::MYSQL::sth::execute called at /home/httpd/cgi-bin/bareedna/admin/GT/SQL/Table.pm line 728 with arguments
(GT::SQL::Driver::MYSQL::sth=HASH(0x84c0960)).
GMail (16649): GT::SQL::Table::do_query called at /home/httpd/cgi-bin/bareedna/admin/GT/SQL/Table.pm line 354 with arguments
(GT::SQL::Table=HASH(0x82f39e8), UPDATE webmail_users SET WHERE userid = '2').
GMail (16649): GT::SQL::Table::update called at /home/httpd/cgi-bin/bareedna/admin/GMail/User.pm line 164 with arguments
(GT::SQL::Table=HASH(0x82f39e8), HASH(0x8305068), HASH(0x82fee54)).
GMail (16649): GMail::User::update_template called at /home/httpd/cgi-bin/bareedna/user/login.cgi line 61 with arguments
(GMail::User=HASH(0x848cc14), simple).
GMail (16649): main::main called at /home/httpd/cgi-bin/bareedna/admin/GT/Plugins.pm line 93 with no arguments.
GMail (16649): GT::Plugins::dispatch called at /home/httpd/cgi-bin/bareedna/user/login.cgi line 28 with arguments
(GT::Plugins=HASH(0x81d2390), login::main, CODE(0x82ce55c)).




Quote Reply
Re: bug: simple template error In reply to
Hi,

You are missing a column, which most likely means the upgrade from 2.0.0 to 2.0.1 did not go successfully. If you are not live, I would just recreate your SQL tables. If you are live, send me info and I can take a look and see what's missing.

Cheers,

Alex

--
Gossamer Threads Inc.