
@ poyntesm
I don't mean to be a A$$ hole but....
Its now 3 weeks sense your last post and October, scene your last update or even login to http://www.phpbbgarage.com!
Should we assume you have abandoned your baby again!
Does some one need to step up and finish this for you?
If you not dedicated to finishing this I told you I would continue the development.
It seems that you only reason why you restarted development is because I wanted to take it over.
Let us garage fans know what your plains are!!!
Please....
Code: Select all
Error General
SQL ERROR [ mysql4 ]
Unknown column 'u.user_id' in 'on clause' [1054]
SQL
SELECT u.user_id, v.id as vid FROM bb_users u , bb_user_group ug LEFT JOIN bb_garage_vehicles v ON ( v.user_id = u.user_id AND v.main_vehicle = 1 ) WHERE u.user_type IN (0, 3) AND ug.user_pending = 0 AND u.user_id = ug.user_id AND ug.group_id = 7556 ORDER BY ug.group_leader DESC, u.user_regdate ASC LIMIT 30
BACKTRACE
FILE: includes/db/mysql.php
LINE: 175
CALL: dbal_mysql->sql_error()
FILE: includes/db/mysql.php
LINE: 222
CALL: dbal_mysql->sql_query()
FILE: includes/db/dbal.php
LINE: 170
CALL: dbal_mysql->_sql_query_limit()
FILE: memberlist.php
LINE: 1502
CALL: dbal_mysql->sql_query_limit()
I solve the problem with this changematt1206 wrote:I fixed this by removing a code change added when installing the garage. Affected file is memberlist.phpthejdm wrote:same error i am getting. very strange. not sure what is causing this.
n00bstorm wrote:And now even when I try to look at my Legend :: Administrators, Global moderators I get this error
Code: Select all
General Error SQL ERROR [ mysqli ] Unknown column 'u.user_id' in 'on clause' [1054] SQL SELECT u.user_id, v.id as vid FROM phpbb_users u , phpbb_user_group ug LEFT JOIN phpbb_garage_vehicles v ON ( v.user_id = u.user_id AND v.main_vehicle = 1 ) WHERE u.user_type IN (0, 3) AND ug.user_pending = 0 AND u.user_id = ug.user_id AND ug.group_id = 5 ORDER BY ug.group_leader DESC, u.user_regdate ASC LIMIT 25 BACKTRACE FILE: includes/db/mysqli.php LINE: 163 CALL: dbal->sql_error() FILE: includes/db/mysqli.php LINE: 205 CALL: dbal_mysqli->sql_query() FILE: includes/db/dbal.php LINE: 170 CALL: dbal_mysqli->_sql_query_limit() FILE: memberlist.php LINE: 1383 CALL: dbal->sql_query_limit()
Change this back to the original codeCode: Select all
// Get us some users :D $sql = "SELECT u.user_id, v.id as vid FROM " . USERS_TABLE . " u $sql_from LEFT JOIN " . GARAGE_VEHICLES_TABLE . " v ON ( v.user_id = u.user_id AND v.main_vehicle = 1 ) WHERE u.user_type IN (" . USER_NORMAL . ', ' . USER_FOUNDER . ") $sql_where ORDER BY $order_by"; $result = $db->sql_query_limit($sql, $config['topics_per_page'], $start);
Code: Select all
// Get us some users :D $sql = "SELECT u.user_id FROM " . USERS_TABLE . " u $sql_from WHERE u.user_type IN (" . USER_NORMAL . ', ' . USER_FOUNDER . ") $sql_where ORDER BY $order_by"; $result = $db->sql_query_limit($sql, $config['topics_per_page'], $start);
Here is a complete rewriteEFiNSTORM wrote:Hey I really like the idea "force garage setup on first login " that would be a great feature.
poyntesm seems to be MIAvesek wrote:In the package is missing this file
./styles/prosilver/template/garage_view_guestbook.html
Is requiered to delete comments on guestbook
I know, my english is bad !! I hope you can understand me
These links will show you everything you need to know!!toricelli wrote:Hi mates,
I checked database and garage files but i can't find CURRENCY data. How to change, delete or add new currency?
http://www.phpbb.com/community/viewtopi ... Y#p8153655
This link give some info but :*(
Updatevesek wrote:In the package is missing this file
./styles/prosilver/template/garage_view_guestbook.html
Is requiered to delete comments on guestbook
I know, my english is bad !! I hope you can understand me