First off, upgrade.php didn't work when going from 3.4.5, so I had to create the calendar table by hand in MySQL. I think the SQL in upgrade.php was coded wrong. (From my limited knowledge of SQL, I think there was a problem with the 0 in id int default '0'.
Now how do you go about reading the file comparison tool? It looks like a bunch of mumbo jumbo to me.
And how can you create a google sitemap? I can't find it in the admin panel, or in the manual. EDIT: It's under SEO in the admin panel, the very last field.
It's a diff file, the standard way of comparing things. < means remove, > means insert.
< x > y
means that the file had x replaced with y between the two versions being compared. A graphical program like kompare (which I use) or examdiff (which some customer endorsed, I recall) is easier to read, you can either load the diff into them or do the comparison from them.
(From my limited knowledge of SQL, I think there was a problem with the 0 in id int default '0'.
What version of mysql do you have? There weren't any problems with the ones I have, but different versions sometimes have odd syntax requirement differences.
Comments on Problems with 4.0.0
Member
Usergroup: Customer
Joined: Aug 04, 2005
Total Topics: 11
Total Comments: 47
First off, upgrade.php didn't work when going from 3.4.5, so I had to create the calendar table by hand in MySQL. I think the SQL in upgrade.php was coded wrong. (From my limited knowledge of SQL, I think there was a problem with the 0 in id int default '0'.
Now how do you go about reading the file comparison tool? It looks like a bunch of mumbo jumbo to me.
Example
Common subdirectories: /home/wsnforum/public_html/filecomparison/wsnlinks/344/templates/default/admin and /home/wsnforum/public_html/filecomparison/wsnlinks/400/templates/default/admin
diff -w /home/wsnforum/public_html/filecomparison/wsnlinks/344/templates/default/albumlist.tpl /home/wsnforum/public_html/filecomparison/wsnlinks/400/templates/default/albumlist.tpl
2c2
< <div class="nav"><a href="https://www.webmastersite.net/forums/">{LANG_NAVORIGIN}</a> > Link Lists</div>
---
> <div class="nav"><a href="{DIRURL}">{LANG_NAVORIGIN}</a> > Link Lists</div>
diff -w /home/wsnforum/public_html/filecomparison/wsnlinks/344/templates/default/albums.tpl /home/wsnforum/public_html/filecomparison/wsnlinks/400/templates/default/albums.tpl
1c1
< <div class="nav"><a href="https://www.webmastersite.net/forums/">{LANG_NAVORIGIN}</a> {NAVIGATION} </div>
---
> <div class="nav"><a href="{DIRURL}">{LANG_NAVORIGIN}</a> {NAVIGATION} </div>
94c94
< <IF {SWITCH_COMMENTS}><a href="comments.php?id={LINKID}"><img src="templates/default/images/linktools_comments.gif" border="0" alt="Comments"> Reviews (<IF {LINKCOMMENTSREAD}>{LINKNUMCOMMENTS}<OTHERWISE><b>{LINKNUMCOMMENTS}</b></IF>)</a></IF>
---
> <IF {SWITCH_COMMENTS}><a href="{LINKTHREADURL}"><img src="templates/default/images/linktools_comments.gif" border="0" alt="Comments"> Reviews (<IF {LINKCOMMENTSREAD}>{LINKNUMCOMMENTS}<OTHERWISE><b>{LINKNUMCOMMENTS}</b></IF>)</a></IF>
134c134
< <IF {SWITCH_COMMENTS}><a href="comments.php?id={LINKID}"><img src="templates/default/images/linktools_comments.gif" border="0" alt="Comments"> Reviews (<IF {LINKCOMMENTSREAD}>{LINKNUMCOMMENTS}<OTHERWISE><b>{LINKNUMCOMMENTS}</b></IF>)</a></IF>
---
And how can you create a google sitemap? I can't find it in the admin panel, or in the manual. EDIT: It's under SEO in the admin panel, the very last field.
Other than that, things are looking good.
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7867
It's a diff file, the standard way of comparing things. < means remove, > means insert. means that the file had x replaced with y between the two versions being compared. A graphical program like kompare (which I use) or examdiff (which some customer endorsed, I recall) is easier to read, you can either load the diff into them or do the comparison from them.
(From my limited knowledge of SQL, I think there was a problem with the 0 in id int default '0'.
What version of mysql do you have? There weren't any problems with the ones I have, but different versions sometimes have odd syntax requirement differences.
Member
Usergroup: Customer
Joined: Aug 04, 2005
Total Topics: 11
Total Comments: 47
MySQL - 4.1.21-standard. This is what it says when I try to run the SQL in PHPMyAdmin
SQL query:
ALTER TABLE market_calendar ADD id int default '0' NOT NULL AUTO_INCREMENT ;
MySQL said: Documentation
#1067 - Invalid default value for 'id'
It is not a problem for me anymore because I entered the fields manually, but for people without any MySQL experience, it might be a problem.