Edit List Comment
Brought to you by:
jab5915
Menu
▾
▴
Logged In: NO
In editListComment.php there should be the following line
<textarea name="catSubDescription" cols="75"
rows="5"></textarea>
That is the textbox used to enter and modify the comment.
Is that in the html source code when you view it?
Logged In: NO
I do have that section in the source file, obviously. However, "Edit List Comment" is the end of the "useful" stuff on the page's source display. After that it's closing meta tags.
And all teh closing metatags are there, so it doesn't look like PHP crapped out:
------------------
<HTML>
<link rel=stylesheet href=../style.css type=text/css>
<BODY>
<table cellspacing="0" cellpadding="5" width="100%" height="100%" bgcolor="#FFFFFF" nosave border="0" style="border: 1px solid rgb(128,255,128)">
<tr>
<td valign="top" >
<table width=100% class="yellowBorder"><tr class="lightYellow"><td width=10%><a class="menuLink" href="../home.php">Home</a> > <a class="menuLink" href="modifyList.php">Modify WishList</a> > <b>Edit List Comment</b></td><td width=10% align="right"><a class=menuLink target="_blank" href="https://midearth.homelinux.org/wishlist/help.php#">Help</a> :: <a class="menuLink" href="https://midearth.homelinux.org/wishlist/logout.php">logout</a></td></tr></table>
<center>
<p>
<p>
<table style="border-collapse: collapse;" id="AutoNumber1" border="1" bordercolor="#11111" cellpadding="2" cellspacing="0" bgcolor="lightyellow">
<tr><td colspan="2" align="center" bgcolor="#6702cc"> <b><font size=3 color="#ffffff">
<b>Edit List Comment</b>
</font></td></tr>
</td></tr></table>
</body>
</html>
Logged In: NO
Looking at the code, I see a query:
$query = "select catSubDescription from categories where userid='" . $_SESSION["userid"] . "' and catSortOrder=-1000";
However, looking at the table I see:
mysql> select userid, catSortOrder from categories;
+--------+--------------+
| userid | catSortOrder |
+--------+--------------+
| george | -10000 |
| george | 2 |
| george | 3 |
| george | 0 |
| george | 1 |
| george | 4 |
+--------+--------------+
6 rows in set (0.00 sec)
one is 10000, the other is 1000...
Logged In: YES
user_id=1550098
Yes, the problem is that there isn't a catSortOrder equal to
-1000. The -1000 category is used for the "Edit List
Comment" field and the -10,000 category is used for the
"Items Under Consideration". I hand modified the sql for
the sample database and I guess I erased the -1000 lines.
I'm going to release a new build soon but you will probably
need to add these categories manually if you haven't done so
yet. The following should work...
insert into categories (catSortOrder, userid) value (-1000,
'george')
Again, sorry for the late reply