Gossamer Forum
Home : Products : Gossamer Forum : Discussion :

gforum_User problem in MySQLMan

Quote Reply
gforum_User problem in MySQLMan
Hi, when I launch MySQLMan from gforum 1.2.0 admin and click on "Browse" for table gforum_User the page has a problem. Instead of just printing the first 20 records in a nice table, it prints the 20 records in a table and prints the same 20 records again at the bottom of the page all jumbled together without a table. I also noticed that all the other tables are doing the same thing when I browse them.

Is something wrong with a template after the upgrade from gforum 1.18 to 1.2.0?

Has anybode else had this problem?

Thanks for any help.

CRUZN8R

----------
Michael J. Challis - CRUZN8R - PT Cruiser Club - http://www.ptcruiserclub.org

http://www.ptcruiserclub.org/forum

Last edited by:

CRUZN8R: Oct 15, 2003, 12:20 PM
Quote Reply
Re: [CRUZN8R] gforum_User problem in MySQLMan In reply to
I found the bug and fixed it. There was an unclosed loop for col_name. This template bug was introduced when I upgraded to gforum 1.2.0

Edit the template gforum/admin/mysqlman/templates/table_browse.html (you have to manually edit and upload by FTP)

Find:

<%loop col_name%>
<TD><B><%if link%><a href=
"<%link%>"><%endif%><%name%><%if link%></a><%endif%></B></TD>
<%if pri_key%>


Replace with:

<%loop col_name%>
<TD><B><%if link%><a href=
"<%link%>"><%endif%><%name%><%if link%></a><%endif%></B></TD>
<%endloop%>
<%if pri_key%>


CRUZN8R


----------
Michael J. Challis - CRUZN8R - PT Cruiser Club - http://www.ptcruiserclub.org

http://www.ptcruiserclub.org/forum
Quote Reply
Re: [CRUZN8R] gforum_User problem in MySQLMan In reply to
Yeah, I came across this bug about a week or two ago in GMail - I didn't realize it had been present in the GForum 1.2.0 release as well. For anyone who is wondering, what CRUZN8R posted is the official fix.

There ought to be a minor 1.2.1 update to GForum in the next week or so that fixes this problem, and offers 2CheckOut payment support, as well as an updated version of the Moneris payment support.

Jason Rhinelander
Gossamer Threads
jason@gossamer-threads.com
Quote Reply
Re: [CRUZN8R] gforum_User problem in MySQLMan In reply to
Re:

Replace with:

<%loop col_name%>
<TD><B><%if link%><a href="<%link%>"><%endif%><%name%><%if link%></a><%endif%></B></TD>
<%endloop%>
<%if pri_key%>
etc

You might also fix the
<%if pri_key%>
<TD></TD><TD></TD>
<%endif%>

to read

<%if pri_key%>
<TD>&nbsp;</TD><TD>&nbsp;</TD>
<%endif%>

As the <td></td> screws up the look of tables but forcing a space fixes that.
doug
Quote Reply
Re: [dougrobb] gforum_User problem in MySQLMan In reply to
And while you are fixing template problems in
property.html you have:


<tr>
<%loop table_columns%>
<td><b><%name%></b></td>
<%endloop%>
<td><th colspan="5">ACTION</td>
</tr>

That should be:

<tr>
<%loop table_columns%>
<td><b><%name%></b></td>
<%endloop%>
<th colspan="5">ACTION</th>
</tr>

(the extra td in from of the <th> and close </th> and not </td>
and

<%loop columns%>
<td><%name%></td>
<%endloop%>

should be
<%loop columns%>
<td>&nbsp;<%name%></td>
<%endloop%>

because if <%name%> is empty the table format looks bad because the border isn't around the empty cell.

doug