| Author |
 Topic  |
|
|
DarlingBri
Junior Member
United Kingdom
378 Posts |
 Posted - 07 December 2002 : 18:53:40
|
I just upgraded my 3.3.05 forum to a new 3.4 forum. The upgrade itself went fine, except for:
1/ Error Message in DB Upgrade
Error: 80040E37 Table 'FORUM_MEMBERS_PENDING' does not exist.
strUpdateSql: DROP TABLE FORUM_MEMBERS_PENDING
...and I have no idea what that means.
2/ Table Layout
The second problem, which is more immediately pressing, is that my site has a left-hand nav bar. In previous versions, it was super-easy to plonk that in... you just opened a table with two rows in inc_header, put your nav in the left cell and started the Snitz code in the right cell.
In inc_footer, you let Snitz close it's tables, and then closed the additions td cell, tr, and table.
I have attempted to do that with the new version, as below, but I'm really bad with this whole quote mark thing. I have made my new code red to hilight the changes. The problem is... the page doesn't load! I get the logo and the login, but no forum and no footer!
inc_header, line 282 (formerly known as inc_top, yes?)
Response.Write "<table align=""center"" border=""0"" cellPadding=""0"" cellSpacing=""0"" width=""100%"">" & vbNewLine & _
" <tr>" & vbNewLine & _
" <td align=""center"" valign=""top"" width=""170"">" & vbNewLine & _
" </td>" & vbNewLine & _
" <td align=""center"" valign=""top"" width=""100%">" & vbNewLine & _
"<table align=""left"" border=""0"" cellPadding=""0"" cellSpacing=""0"" width=""100%"">" & vbNewLine & _
" <tr>" & vbNewLine &
inc_footer, line 75:
Response.Write " </tr>" & vbNewLine & _
"</table>" & vbNewLine & _
"</td>" & vbNewLine & _
"</tr>" & vbNewLine & _
"</table>" & vbNewLine & _
"</font>" & vbNewLine & _
"</body>" & vbNewLine & _
"</html>" & vbNewLine
3/ I would also appreciate it if someone could tell me how to include a file in that first bot of code, in the box that's 170 px wide. I don't know how to do the quote mark thingies for my include statement, or the syntax for including it:
<!--#include file="../includes/inc_forum.asp"-->
Any help appreciated as always!
edited to add line numbers |
Edited by - DarlingBri on 07 December 2002 19:06:00 |
|
|
laser
Advanced Member
Australia
3859 Posts |
Posted - 07 December 2002 : 19:03:59
|
1/ Probably not worth worrying about, just means that the upgrade was trying to delete a table which doesn't exist anyway.
2/ Looks almost the same as what I did to achieve the same results. Any chance of a url ?
3/ Your include syntax looks fine, although you might have to use 'virtual' rather than 'file'. You might have to do this :
%><!--#include file="../includes/inc_forum.asp"--><%
|
 |
|
|
D3mon
Senior Member
United Kingdom
1685 Posts |
|
|
DarlingBri
Junior Member
United Kingdom
378 Posts |
Posted - 07 December 2002 : 19:09:44
|
Sure! http://www.centrallondonconnexions.co.uk/forum2/
I'm aware the image is broken, but that's the least of my problems! |
*****
"You know, there's nothing sexier than a girl geek on a big coding run." -Doonesbury |
|
|
|
DarlingBri
Junior Member
United Kingdom
378 Posts |
Posted - 07 December 2002 : 19:14:13
|
EVERYONE is too quick :)
D3mon, what does your site integration mod do? I am happy to try it, but if you think my installs are a nightmare, my uninstalls are worse 
So, would that be:
" <td align=""center"" valign=""top"" width=""170"">" & vbNewLine & _
" <!--#include file=""../includes/inc_forum.asp""--> & vbNewLine & _
" </td>" & vbNewLine & _
?
|
*****
"You know, there's nothing sexier than a girl geek on a big coding run." -Doonesbury |
|
|
|
D3mon
Senior Member
United Kingdom
1685 Posts |
|
|
laser
Advanced Member
Australia
3859 Posts |
Posted - 07 December 2002 : 20:26:17
|
More like ...
" <td align=""center"" valign=""top"" width=""170"">"
%>
<!--#include file="../includes/inc_forum.asp"-->
<%
Response.Write vbNewLine & _
" </td>" & vbNewLine & _
You can't have an include with ASP, because the #include statements are processed first. |
|
|
|
DarlingBri
Junior Member
United Kingdom
378 Posts |
Posted - 07 December 2002 : 21:34:13
|
OK, thank you for all the help. I really am grateful :)
I used the Snitz Integration Mod, and it seems to work well, except I have a width problem.
I did some further editing of inc_header(gulp) to get what I want, and I'm *almost* there. Here is my width problem and one thing I'm wondering about:
1/ Problem
I changed my inc_header to take out the forum title and make my nav links in the middle on a purple table cell, as follows:
"<table align=""center"" border=""0"" cellPadding=""0"" cellSpacing=""0"" width=""100%"">" & vbNewLine & _
" <tr>" & vbNewLine & _
" <td align=""center"" valign=""top"" width=""100%"">" & vbNewLine & _
" <table border=""0"" cellPadding=""2"" cellSpacing=""0"" width=""100%"">" & vbNewLine & _
" <tr>" & vbNewLine & _
" <td align=""center"" colspan=""2"" bgcolor=""#50076F"" width=""100%""><font face=""" & strDefaultFontFace & """ size=""" & strDefaultFontSize & """>" & vbNewLine
call sForumNavigation()
Response.Write "</font></td>" & vbNewLine & _
" </tr>" & vbNewLine
...but the purple row (50076F) isn't 100% all the time. It is on the forum home page, but on all the other pages there's a gap :(
Is it something to do with the 95% tags?
2/ When you turn board registration off, it doesn't stop you writing to the tables, does it? I've turned registration off for security, but I'm handling registration in another way using a form I built. That will still work, right?
(Turning registration off, you can see the width prblem with the purple line, btw...)
Thank you again. |
*****
"You know, there's nothing sexier than a girl geek on a big coding run." -Doonesbury |
Edited by - DarlingBri on 07 December 2002 21:35:50 |
|
|
|
DarlingBri
Junior Member
United Kingdom
378 Posts |
Posted - 08 December 2002 : 04:10:16
|
| For the record, I fixed the width problem by editing the Snitz Integration Mod to inc_header. All that was required was adding a declaration of the td width, and hey presto, fixed! |
*****
"You know, there's nothing sexier than a girl geek on a big coding run." -Doonesbury |
|
|
| |
Topic |
|
Topic Locked
