Search options (Page 1 of 2)

SQL-query : 
SELECT users.username, posts.poster FROM users INNER JOIN posts ON posts.poster_id=users.id LIMIT 0, 30
MySQL said:
You have an error in your SQL syntax near 'ON posts.poster_id=users.id LIMIT 0, 30' at line 1

SQL-query : 
SELECT u.username, p.poster FROM users AS u INNER JOIN posts AS p ON p.poster_id=u.id LIMIT 0, 30
MySQL said:
You have an error in your SQL syntax near 'INNER JOIN posts AS p ON p.poster_id=u.id LIMIT 0, 30' at line 1

SQL-query : 
SELECT u.username, p.poster FROM users u INNER JOIN posts p ON p.poster_id=u.id LIMIT 0, 30
MySQL said:
You have an error in your SQL syntax near 'INNER JOIN posts p ON p.poster_id=u.id LIMIT 0, 30' at line 1

Is this relevant?

For some reason, my system is not liking 'SHOW TABLE STATUS' and 'INNER JOIN'

I'll see what it does

This stinks.  I really like your forum and I want to use it.  I stayed up all night looking for something on hotscripts.com and nothing fits my needs like yours.  I really want to make this work.

That didn't do anything.

I've never seen these quote marks before:  FROM `'.$db_name.'`')

the ones outside of '.$db_name.' , I'm on Mac OSX and I'm wondering if I'm translating a windows character incorrectly.

Line 58:

$result = $db->query('SHOW TABLE STATUS FROM `'.$db_name.'`') or error('Unable to fetch table status', __FILE__, __LINE__, $db->error());

Line 64:

$result = $db->query('SELECT c.id AS cid, c.cat_name, f.id AS fid, f.forum_name, f.forum_desc, f.moderators, f.num_topics, f.num_posts, f.last_post, f.last_post_id, f.last_poster, f.closed FROM '.$db->prefix.'categories AS c INNER JOIN '.$db->prefix.'forums AS f ON c.id=f.cat_id'.$extra.' ORDER BY c.position, cid, f.position') or error('Unable to fetch category/forum list', __FILE__, __LINE__, $db->error());

I am now a 'Member'!  Wahooooo!!!

Did that too - didn't fix it