Webmastersite.net
Register Log In

Problems with 4.0.0

Comments on Problems with 4.0.0

scriptwiki
Member

Usergroup: Customer
Joined: Aug 04, 2005

Total Topics: 11
Total Comments: 47
Posted Oct 07, 2006 - 10:13 PM:

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>
---
How do you read that?

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. smiling face

Other than that, things are looking good.
Paul
developer

Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California

Total Topics: 61
Total Comments: 7868
Paul
Posted Oct 08, 2006 - 4:52 PM:

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.
scriptwiki
Member

Usergroup: Customer
Joined: Aug 04, 2005

Total Topics: 11
Total Comments: 47
Posted Oct 08, 2006 - 6:09 PM:

MySQL - 4.1.21-standard. This is what it says when I try to run the SQL in PHPMyAdmin

Error

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.
Search thread for
Download thread as
  • 0/5
  • 1
  • 2
  • 3
  • 4
  • 5



This thread is closed, so you cannot post a reply.