Pomoc - Szukaj - Użytkownicy - Kalendarz
Pełna wersja: [Symfony] Błąd połączenia z bazą
Forum PHP.pl > Forum > PHP > Frameworki
zalazdi
15.04.2011, 17:04:53
Witam,
mam mały problem z symfony (orm - doctrine). Chciałem przenieść skrypt z localhosta na serwer, aby pokazać klientowi postępy. Wrzuciłem wszystko, zmieniłem dane do bazy, wrzuciłem zrzut bazy przez PMA i ... nie działa.
Kod
Notice: Undefined index: in /home/crowntuf/public_html/tz/lib/vendor/symfony/lib/plugins/sfDoctrinePlugin/lib/vendor/doctrine/Doctrine/Hydrator/Graph.php on line 302

Notice: Undefined index: in /home/crowntuf/public_html/tz/lib/vendor/symfony/lib/plugins/sfDoctrinePlugin/lib/vendor/doctrine/Doctrine/Hydrator/Graph.php on line 303

Fatal error: Call to a member function getFieldName() on a non-object in /home/crowntuf/public_html/tz/lib/vendor/symfony/lib/plugins/sfDoctrinePlugin/lib/vendor/doctrine/Doctrine/Hydrator/Graph.php on line 304

Taki jest błąd przy pierwszym pobraniu i wyświetleniu danych z bazy (w moim przypadku menu). Dalej strona się nie renderuje. Nie mogę zrobić testów, bo jest to wirtualny serwer.

Łączyłem się z bazą danych w oddzielnym skrypcie php, wszystko działa w porządku. Normalnie pobiera tabele, wyświetla itd.

Z czym może być problem?
l3l0
15.04.2011, 17:15:53
Witam,

Może to ci pomoże:
http://symfonyexperts.com/question/show/id/178

Ktoś miał podobny problem. Spróbuj odpalić "./symfony doctrine:clean-model-files" i sprawdz scheme.

Pozdrawiam
zalazdi
15.04.2011, 17:25:31
Kod
C:\Users\buba\Desktop\tz>php symfony doctrine:clean-model-files
>> file+     C:\Users\buba\AppData\Local\Temp/doctrine_schema_70873.yml
>> doctrine  Could not find any files that need to be removed

C:\Users\buba\Desktop\tz>php symfony doctrine:build --model
>> doctrine  generating model classes
>> file+     C:\Users\buba\AppData\Local\Temp/doctrine_schema_32815.yml
>> tokens    C:/Users/buba/Desktop/tz/lib/mo...octrine/base/BaseBets.class.php
>> tokens    C:/Users/buba/Desktop/tz/lib/mo...ne/base/BaseBookmaker.class.php
>> tokens    C:/Users/buba/Desktop/tz/lib/mo...ine/base/BaseCategory.class.php
>> tokens    C:/Users/buba/Desktop/tz/lib/mo...rine/base/BaseComment.class.php
>> tokens    C:/Users/buba/Desktop/tz/lib/mo...trine/base/BaseGarpes.class.php
>> tokens    C:/Users/buba/Desktop/tz/lib/mo...ase/BaseGarpesComment.class.php
>> tokens    C:/Users/buba/Desktop/tz/lib/mo...trine/base/BaseLatest.class.php
>> tokens    C:/Users/buba/Desktop/tz/lib/mo...octrine/base/BaseNews.class.php
>> tokens    C:/Users/buba/Desktop/tz/lib/mo...ne/base/BaseSpelskola.class.php
>> tokens    C:/Users/buba/Desktop/tz/lib/mo.../BaseSpelskolaComment.class.php
>> tokens    C:/Users/buba/Desktop/tz/lib/mo...sfGuardForgotPassword.class.php
>> tokens    C:/Users/buba/Desktop/tz/lib/mo...base/BasesfGuardGroup.class.php
>> tokens    C:/Users/buba/Desktop/tz/lib/mo...fGuardGroupPermission.class.php
>> tokens    C:/Users/buba/Desktop/tz/lib/mo...BasesfGuardPermission.class.php
>> tokens    C:/Users/buba/Desktop/tz/lib/mo...asesfGuardRememberKey.class.php
>> tokens    C:/Users/buba/Desktop/tz/lib/mo.../base/BasesfGuardUser.class.php
>> tokens    C:/Users/buba/Desktop/tz/lib/mo.../BasesfGuardUserGroup.class.php
>> tokens    C:/Users/buba/Desktop/tz/lib/mo...sfGuardUserPermission.class.php
>> autoload  Resetting application autoloaders
>> file-     C:/Users/buba/Desktop/tz/cache/.../config/config_autoload.yml.php
>> file-     C:/Users/buba/Desktop/tz/cache/.../config/config_autoload.yml.php


Wykonałem to polecenie i przebudowałem modele, plik schema jest odpowiedni (na localhoście działa). Niestety błędu to nie naprawiło.

EDIT: W razie czego, to cache czyszczę co chwilę i testuję na "dev", chociaż nawet nie dochodzi do etapu wyświetlenia web bara.
l3l0
15.04.2011, 19:06:48
Witam,

Rozumiem że swoją maszynę developerską masz na Windowsie, a prod stoi na linuxie? Taski powinny być uruchomione tam gdzie wystąpił problem czyli na serwerze liniuxowym. Jako iż to wirtualny, współdzielony hosting możesz mieć problem. Możesz spróbować usunąć wszystkie wygenerowane klasy z lib/model/base/* , i skopiować te pliki z deva ale nie jestem pewien czy coś Ci to pomoże. Spróbuj też usunąć wszystko z katalogu cache/*

Tak na marginesie najlepiej zautomatyzować proces deploymentu np. używając tego https://github.com/everzet/capifony

Pozdrawiam
zalazdi
16.04.2011, 10:20:37
Sprawdziłem wszystko na innym serwerze współdzielonym i ... działa... Wygląda na jakiś problem z serwerem. Sprawdzałem jeszcze czy ogólnie doctrine chce się połaczyć z bazą, i jak zmieniłem hasło na niepoprawne w databases.yml to jest błąd
Kod
PDO Connection Error: SQLSTATE[28000] [1045] Access denied for user 'crowntuf_tz'@'localhost' (using password: TAK)


EDIT:
Dorzucam jeszcze logi, hosting gdzie skrypt nie działa:
Kod
Apr 16 11:35:04 symfony [info] {sfPatternRouting} Connect sfRoute "sf_guard_signin" (/guard/login)
Apr 16 11:35:04 symfony [info] {sfPatternRouting} Connect sfRoute "sf_guard_signout" (/guard/logout)
Apr 16 11:35:04 symfony [info] {sfPatternRouting} Connect sfRoute "sf_guard_register" (/guard/register)
Apr 16 11:35:04 symfony [info] {sfPatternRouting} Connect sfRoute "sf_guard_forgot_password" (/guard/forgot_password)
Apr 16 11:35:04 symfony [info] {sfPatternRouting} Connect sfDoctrineRoute "sf_guard_forgot_password_change" (/guard/forgot_password/:unique_key)
Apr 16 11:35:04 symfony [info] {sfPatternRouting} Match route "homepage" (/) for / with parameters array (  'module' => 'news',  'action' => 'index',)
Apr 16 11:35:04 symfony [info] {sfFilterChain} Executing filter "sfRenderingFilter"
Apr 16 11:35:04 symfony [info] {sfFilterChain} Executing filter "sfExecutionFilter"
Apr 16 11:35:04 symfony [info] {newsActions} Call "newsActions->executeIndex()"
Apr 16 11:35:04 symfony [info] {Doctrine_Connection_Mysql} exec : SET NAMES 'UTF8' - ()
Apr 16 11:35:04 symfony [info] {Doctrine_Connection_Mysql} query : SELECT l.news_id AS l__news_id, l.author_id AS l__author_id, l.title AS l__title, l.content AS l__content, l.img AS l__img, l.tb AS l__tb, l.created_at AS l__created_at, l.updated_at AS l__updated_at FROM latest l ORDER BY l.created_at DESC LIMIT 10 - ()
Apr 16 11:35:08 symfony [info] {sfPatternRouting} Connect sfRoute "sf_guard_signin" (/guard/login)
Apr 16 11:35:08 symfony [info] {sfPatternRouting} Connect sfRoute "sf_guard_signout" (/guard/logout)
Apr 16 11:35:08 symfony [info] {sfPatternRouting} Connect sfRoute "sf_guard_register" (/guard/register)
Apr 16 11:35:08 symfony [info] {sfPatternRouting} Connect sfRoute "sf_guard_forgot_password" (/guard/forgot_password)
Apr 16 11:35:08 symfony [info] {sfPatternRouting} Connect sfDoctrineRoute "sf_guard_forgot_password_change" (/guard/forgot_password/:unique_key)
Apr 16 11:35:08 symfony [info] {sfPatternRouting} Match route "default_index" (/:module) for /news with parameters array (  'module' => 'news',  'action' => 'index',)
Apr 16 11:35:08 symfony [info] {sfFilterChain} Executing filter "sfRenderingFilter"
Apr 16 11:35:08 symfony [info] {sfFilterChain} Executing filter "sfExecutionFilter"
Apr 16 11:35:08 symfony [info] {newsActions} Call "newsActions->executeIndex()"
Apr 16 11:35:08 symfony [info] {Doctrine_Connection_Mysql} exec : SET NAMES 'UTF8' - ()
Apr 16 11:35:08 symfony [info] {Doctrine_Connection_Mysql} query : SELECT l.news_id AS l__news_id, l.author_id AS l__author_id, l.title AS l__title, l.content AS l__content, l.img AS l__img, l.tb AS l__tb, l.created_at AS l__created_at, l.updated_at AS l__updated_at FROM latest l ORDER BY l.created_at DESC LIMIT 10 - ()


Hosting gdzie skrypt działa jak powinien
Kod
Apr 16 11:33:31 symfony [info] {sfPatternRouting} Connect sfRoute "sf_guard_signin" (/guard/login)
Apr 16 11:33:31 symfony [info] {sfPatternRouting} Connect sfRoute "sf_guard_signout" (/guard/logout)
Apr 16 11:33:31 symfony [info] {sfPatternRouting} Connect sfRoute "sf_guard_register" (/guard/register)
Apr 16 11:33:31 symfony [info] {sfPatternRouting} Connect sfRoute "sf_guard_forgot_password" (/guard/forgot_password)
Apr 16 11:33:31 symfony [info] {sfPatternRouting} Connect sfDoctrineRoute "sf_guard_forgot_password_change" (/guard/forgot_password/:unique_key)
Apr 16 11:33:31 symfony [info] {sfPatternRouting} Match route "homepage" (/) for / with parameters array (  'module' => 'news',  'action' => 'index',)
Apr 16 11:33:31 symfony [info] {sfFilterChain} Executing filter "sfRenderingFilter"
Apr 16 11:33:31 symfony [info] {sfFilterChain} Executing filter "sfExecutionFilter"
Apr 16 11:33:31 symfony [info] {newsActions} Call "newsActions->executeIndex()"
Apr 16 11:33:31 symfony [info] {Doctrine_Connection_Mysql} exec : SET NAMES 'UTF8' - ()
Apr 16 11:33:31 symfony [info] {Doctrine_Connection_Mysql} query : SELECT l.news_id AS l__news_id, l.author_id AS l__author_id, l.title AS l__title, l.content AS l__content, l.img AS l__img, l.tb AS l__tb, l.created_at AS l__created_at, l.updated_at AS l__updated_at FROM latest l ORDER BY l.created_at DESC LIMIT 10 - ()
Apr 16 11:33:31 symfony [info] {sfPHPView} Render "/home/zalazdi/domains/zalazdi.ozzi.pl/public_html/tipszonen/apps/frontend/modules/news/templates/indexSuccess.php"
Apr 16 11:33:31 symfony [info] {main} Set slot "title"
Apr 16 11:33:31 symfony [info] {main} Call "expert->executeExperttips()"
Apr 16 11:33:31 symfony [info] {sfPartialView} Render "/home/zalazdi/domains/zalazdi.ozzi.pl/public_html/tipszonen/apps/frontend/modules/expert/templates/_experttips.php"
Apr 16 11:33:31 symfony [info] {main} Call "expert->executeExpertstats()"
Apr 16 11:33:31 symfony [info] {sfPartialView} Render "/home/zalazdi/domains/zalazdi.ozzi.pl/public_html/tipszonen/apps/frontend/modules/expert/templates/_expertstats.php"
Apr 16 11:33:31 symfony [info] {sfPHPView} Decorate content with "/home/zalazdi/domains/zalazdi.ozzi.pl/public_html/tipszonen/apps/frontend/templates/layout.php"
Apr 16 11:33:31 symfony [info] {sfPHPView} Render "/home/zalazdi/domains/zalazdi.ozzi.pl/public_html/tipszonen/apps/frontend/templates/layout.php"
Apr 16 11:33:31 symfony [info] {main} Get slot "title"
Apr 16 11:33:31 symfony [info] {main} Get slot "background"
Apr 16 11:33:31 symfony [info] {main} Call "category->executeMenu()"
Apr 16 11:33:31 symfony [info] {Doctrine_Connection_Mysql} query : SELECT c.id AS c__id, c.name AS c__name, c.background AS c__background, c.created_at AS c__created_at, c.updated_at AS c__updated_at FROM category c - ()
Apr 16 11:33:31 symfony [info] {sfPartialView} Render "/home/zalazdi/domains/zalazdi.ozzi.pl/public_html/tipszonen/apps/frontend/modules/category/templates/_menu.php"
Apr 16 11:33:31 symfony [info] {main} Call "sfGuardUser->executeMenu()"
Apr 16 11:33:31 symfony [info] {Doctrine_Connection_Statement} execute : SELECT s.id AS s__id, s.name AS s__name, s.description AS s__description, s.created_at AS s__created_at, s.updated_at AS s__updated_at FROM sf_guard_group s WHERE (s.name = ?) - (expert)
Apr 16 11:33:31 symfony [info] {sfPartialView} Render "/home/zalazdi/domains/zalazdi.ozzi.pl/public_html/tipszonen/apps/frontend/modules/sfGuardUser/templates/_menu.php"
Apr 16 11:33:31 symfony [info] {Doctrine_Connection_Statement} execute : SELECT s.id AS s__id, s.first_name AS s__first_name, s.last_name AS s__last_name, s.email_address AS s__email_address, s.username AS s__username, s.algorithm AS s__algorithm, s.salt AS s__salt, s.password AS s__password, s.is_active AS s__is_active, s.is_super_admin AS s__is_super_admin, s.last_login AS s__last_login, s.created_at AS s__created_at, s.updated_at AS s__updated_at, s2.user_id AS s2__user_id, s2.group_id AS s2__group_id, s2.created_at AS s2__created_at, s2.updated_at AS s2__updated_at FROM sf_guard_user s LEFT JOIN sf_guard_user_group s2 ON s.id = s2.user_id WHERE (s2.group_id IN (?)) - (3)
Apr 16 11:33:31 symfony [info] {sfWebResponse} Send status "HTTP/1.1 200 OK"
Apr 16 11:33:31 symfony [info] {sfWebResponse} Send header "Content-Type: text/html; charset=utf-8"
Apr 16 11:33:31 symfony [info] {sfWebDebugLogger} Configuration 1.79 ms (14)
Apr 16 11:33:31 symfony [info] {sfWebDebugLogger} Factories 25.02 ms (1)
Apr 16 11:33:31 symfony [info] {sfWebDebugLogger} Action "news/index" 25.75 ms (1)
Apr 16 11:33:31 symfony [info] {sfWebDebugLogger} Database (Doctrine) 0.02 ms (5)
Apr 16 11:33:31 symfony [info] {sfWebDebugLogger} View "Success" for "news/index" 39.28 ms (1)
Apr 16 11:33:31 symfony [info] {sfWebDebugLogger} Component "expert/experttips" 0.01 ms (1)
Apr 16 11:33:31 symfony [info] {sfWebDebugLogger} Partial "expert/_experttips" 0.32 ms (1)
Apr 16 11:33:31 symfony [info] {sfWebDebugLogger} Component "expert/expertstats" 0.01 ms (1)
Apr 16 11:33:31 symfony [info] {sfWebDebugLogger} Partial "expert/_expertstats" 0.31 ms (1)
Apr 16 11:33:31 symfony [info] {sfWebDebugLogger} Component "category/menu" 2.34 ms (1)
Apr 16 11:33:31 symfony [info] {sfWebDebugLogger} Partial "category/_menu" 0.69 ms (1)
Apr 16 11:33:31 symfony [info] {sfWebDebugLogger} Component "sfGuardUser/menu" 6.07 ms (1)
Apr 16 11:33:31 symfony [info] {sfWebDebugLogger} Partial "sfGuardUser/_menu" 9.08 ms (1)
Apr 16 11:33:31 symfony [info] {sfWebResponse} Send content (58371 o)
lukas.skowronski
28.04.2011, 15:54:22
Brak dostępu do bazy można odebrać jednoznacznie. Albo złe dane (literowka), albo użytkownik nie ma praw do łączenia się z zewnątrz, albo próbujesz łączyć się na porcie który jest niedostępny.
To jest wersja lo-fi głównej zawartości. Aby zobaczyć pełną wersję z większą zawartością, obrazkami i formatowaniem proszę kliknij tutaj.
Invision Power Board © 2001-2025 Invision Power Services, Inc.