Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl Monk, Perl Meditation
 
PerlMonks  

DBIC::Schema -- no tables found

by madison.sacd (Novice)
on Mar 27, 2007 at 11:01 UTC ( #606738=perlquestion: print w/ replies, xml ) Need Help??
madison.sacd has asked for the wisdom of the Perl Monks concerning the following question:

Dear Monks,

I am a beginner of Catalyst.
I am trying to create a data model with schema helper.

The environment of my computer:

Windows xp
MySql database 5.0
ActivePerl 5.8.8
Catalyst 5.69

I used the following command:

myapp_create.pl model MyModel DBIC::Schema MySchema create=static "dbi:mysql:test:localhost:3307" root 1234


The schema helper can access MySql database successfully. However, another problem happened, no tables found. Actually, I have two tables in the database.

The message is like this:

No tables found in database, nothing to load at C:/Perl/site/lib/DBIx/ +Class/Schema/Loader/Base.pm line 443. Dumping manual schema for MyappDB to directory C:\Perl\site\bin\MyApp\ +lib ... C:\Perl\site\bin\MyApp\lib/MyappDB.pm exists, will not overwrite Schema dump completed.
I have tried to install MySQL version 4.1 but the situation was same.

What should I do?
Please give me some hints. Tkanks!!!

Comment on DBIC::Schema -- no tables found
Select or Download Code
Replies are listed 'Best First'.
Re: DBIC::Schema -- no tables found
by LTjake (Prior) on Mar 27, 2007 at 11:25 UTC

    Unfortunately, I don't have a direct answer for you. But, in order to try and diagnose the error, try the following:

    • Make sure DBIx::Class::Schema::Loader is up-to-date (version 0.03009)
    • Fix your connect string. the proper syntax is: dbi:mysql:database=$database;host=$hostname;port=$port (at least according to the DBD::mysql docs)

    See if those help you at all...

    --
    "Go up to the next female stranger you see and tell her that her "body is a wonderland."
    My hypothesis is that she’ll be too busy laughing at you to even bother slapping you.
    " (src)

Re: DBIC::Schema -- no tables found
by LTjake (Prior) on Mar 29, 2007 at 13:43 UTC

    There have been a couple similar reports to the DBIC mailing list recently. Brandon Black has released a new version of DBIx::Class::Schema::Loader (0.03010 -- link will work soon) which might fix your problems.

    --
    "Go up to the next female stranger you see and tell her that her "body is a wonderland."
    My hypothesis is that she’ll be too busy laughing at you to even bother slapping you.
    " (src)

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: perlquestion [id://606738]
Approved by Corion
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others musing on the Monastery: (13)
As of 2015-07-31 15:25 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (279 votes), past polls