November 19 2017 10:14:47
Navigation
· Home
· Articles
· Downloads
· FAQ
· Discussion Forum
· News Categories
· Contact Me
· Search
Demos
· Glossary
· Netquery
Users Online
· Guests Online: 1

· Members Online: 0

· Total Members: 1,892
· Newest Member: skalsted
Last Seen Users
· batbaru1 2 weeks
· Froberg 5 weeks
· skalsted59 weeks
· muscapaul59 weeks
· webcheck69 weeks
· HopeyS70 weeks
· WildHaggis121 weeks
· grover130 weeks
· fawwaz136 weeks
· tigracar151 weeks
PHP Classes
Support sites
Fusion Sites
PHP-Fusion
PHP-Fusion Mods
PHP-Fusion Themes
PHP-Fusion Beta

PHPfusion-mods.net
StarglowOne
SiteMaster style
wibix.de

Noyoshi.dk



Fuzed Themes
View Thread
Who is here? 1 guest(s)
 Print Thread
Terms Infusion v3.XX
gdaze
#41 Print Post
Posted on 21-07-2010 08:03
Member

Posts: 12
Joined: 07.12.07

Hi Paul, I just tried mucking around with this again on a test mySQL DB.

I imported close on 6800 terms records into the DB, only for other parts of the DB to be rendered inoperable due to SQL and Server errors, timeouts etc. I then emptied out the Terms table, and things returned to normal again.

I am hoping that the Terms Infusion does not get bogged down by adding many entries into the DB.

I'll check the quality of the CSV file I used for importing, just to make sure it was alright. I did have a look at the Terms Infusion online, and the data appeared to be ok.

I'll write back soon.

George
 
gdaze
#42 Print Post
Posted on 21-07-2010 09:15
Member

Posts: 12
Joined: 07.12.07

Hi again Paul, I worked it out.. there was a missing delimiter character in my export/import CSV file. It works ok now. Looking good, though I have a couple of other queries which I will address in another post very soon. G
 
gdaze
#43 Print Post
Posted on 22-07-2010 06:32
Member

Posts: 12
Joined: 07.12.07

Actually, I have tried importing a smaller dataset with all fields set as 'text' with values encapsulated in double quote marks. They get into the DB table AOK, but there are issues with the relevant Includes file, which says something about there missing a delimiter referemce. I can't make it out, but as a result, it impacts on all other areas of PHP Fusion (News, Articles, Forums). I have to empty the Terms table so I can access those other areas again. I'll keep testing, see what else I can find.
 
gdaze
#44 Print Post
Posted on 24-07-2010 05:49
Member

Posts: 12
Joined: 07.12.07

Ok, I see how you have prevented the use of the single quote/apostrophe mark in a term. i was testing the Term Title with persons names. This obviously wouldn't work if you had a whole bunch of Irish names like O'Connor or O'Brien'. Also, I was volume testing the Terms table. The more records you put in it, the more the entire mySQL database grinds to a halt. There must be some piece of code which runs a checking routine per record, which means the more records available, the more the system has to check, which in turn - slows the DB.
 
lelebart
#45 Print Post
Posted on 09-04-2011 21:20
User Avatar

Member

Posts: 7
Joined: 12.05.07

any updates for 7.01? (7.02?)
I don't know! I don't know why I did it, I don't know why I enjoyed it, and I don't know why I'll do it again! Bart Simspon
 
http://www.valeriovendrame.it
muscapaul
#46 Print Post
Posted on 27-04-2011 18:39
User Avatar

Super Administrator

Posts: 368
Joined: 24.03.06

Nope, I have virtually no time to develop these days.
Paul

Time flies like an arrow, fruit flies like banana (Groucho Marx)

sites: www.diptera.info (site owner); www.phpfusion-ned... (superadministrator)
 
Jump to Forum:
Similar Threads
Thread Forum Replies Last Post
Infusion extended profile Infusions 2 24-06-2011 09:19
Button Panel Infusion v2.xx Infusions 20 09-03-2011 02:16
Newsletter Infusion v2.xx Infusions 92 11-06-2010 15:02
Open Newsletter Infusion v2.00 Infusions 4 04-02-2010 17:26
Error Reports Infusion v3.xx Infusions 20 06-01-2010 13:04
Donate
Please help to make
muscapaul.com
possible and enable
further improvements!
Login
Username

Password



Forgotten your password?
Request a new one here.
Temporary email addresses
Please note: While activating new accounts I usually check them out. If I notice an account registered with a temporary email address it will be deleted.
Newsletter
Newsletters are for registered members only.
Shoutbox
You must login to post a message.

10/11/2013 18:48
Cool! This site is still around!

18/10/2013 15:28
hey! Smile

24/06/2011 20:40
My name is Andreo, I'm new member Smile

24/06/2011 20:39
Hello Muscapaul, is there anyone here ?

12/09/2010 20:02
nice mod thanks Smile

10/07/2010 10:01
Paul, hows thing?

06/07/2010 22:47
Who becomes the world champion on football? We wil

02/07/2010 10:11
Do you like buritas or tako? Britney likes it

01/07/2010 09:38
And after all and the truth it has well turned out.

25/06/2010 15:53
I hate Spammers, and whats about that very silly cop-thing?

Render time: 0.05 seconds 3,912,862 unique visits