Skip Menu |

Preferred bug tracker

Please visit the preferred bug tracker to report your issue.

This queue is for tickets about the DBIx-Abstract CPAN distribution.

Report information
The Basics
Id: 47319
Status: resolved
Priority: 0/
Queue: DBIx-Abstract

People
Owner: WINTER [...] cpan.org
Requestors: asash [...] lvk.cs.msu.su
Cc:
AdminCc:

Bug Information
Severity: (no value)
Broken in: (no value)
Fixed in: (no value)



Subject: strange error
Date: Thu, 25 Jun 2009 04:26:29 +0400
To: bug-DBIx-Abstract [...] rt.cpan.org
From: Alexandr Petrov <asash [...] lvk.cs.msu.su>
Hi! I have a strange problem with dbix-abstract. This is tables of my datebase: |mysql> show tables -> ; +------------------+ | Tables_in_stats | +------------------+ | budget | | lostcodes | | pbase | | pcall | | pcall_full | | project | | projects2users | | sessions | | users | | users_details | | vpbases | | vpbases_mat | | vpcalls | | vstatdetails | | vstatdetails2 | | vstatdetails_mat | | vstatistics | | vstatistics_mat | +------------------+ 18 rows in set (0.00 sec) this is dump of db object: | |$VAR1 = bless( { 'sth' => bless( {}, 'DBI::st' ), 'options' => { 'loglevel' => 0 }, 'Active' => 1, 'dbh' => bless( {}, 'DBI::db' ), 'connect' => { 'data_source' => 'dbi:mysql:stats:localhost:', 'password' => '1', 'user' => 'root', 'port' => undef, 'host' => 'localhost', 'dbname' => 'stats', 'driver' => 'mysql' } }, 'DBIx::Abstract' ); | when i do "query SELECT * FROM vpbases" I have strange error message: DBIx::Abstract (execute): There is no 'qwer'@'localhost' registered SQL: SELECT * FROM vpbases STACK TRACE at /usr/share/perl5/DBIx/Abstract.pm line 371 DBIx::Abstract::query('DBIx::Abstract=HASH(0xa3cf548)', 'SELECT * FROM vpbases') called at ../../../lib/Stats.pm line 627 Stats::phone_search_cnt('Stats=HASH(0xa3f3148)', 'phone', undef, 'date_ot', undef, 'date_do', undef) called at /home/asash/projects/stats/cgi-bin/bin/public/pcall/pcall.cgi line 50 But when in same place I do query "query SELECT * FROM pbase" all is ok. I think it is really strange. -- best regards Alexandr Petrov
Years later (sorry!) but I'm pretty sure I know what your problem is. I'm willing to be that vpbases was a view, and that the view configuration was referencing a user that didn't exist in your local database.