Not a request but a Problem [Archive]

View Full Version : Not a request but a Problem

Mr_P

10-21-2002, 01:09 PM

Hope you can follow me on this one .

me tester board which is hack free is giving 25-27 queries as standard is that correct and thats with a clean install.

Now i take the user table from my boards database (nothing else just the user table to get members name/passwprd/email etc)

Now the queries rise to 91

How is this possible with no hacks installed and is there hope for me to reduce the queries.I dont want all the members to have to re reg but i also dont want all them queries running esp when i aint installed any hacks.

Now remember this is a fresh install and all i want is the info from main board sucah as pass /email

but when i download the user table and run it as a query here is a list of what it runs.

DROP TABLE IF EXISTS user;
CREATE TABLE user (
userid int(10) unsigned NOT NULL auto_increment,
usergroupid smallint(5) unsigned NOT NULL,
username varchar(50) NOT NULL,
password varchar(50) NOT NULL,
email varchar(50) NOT NULL,
styleid smallint(5) unsigned NOT NULL,
parentemail varchar(50) NOT NULL,
coppauser smallint(6) NOT NULL,
homepage varchar(100) NOT NULL,
icq varchar(20) NOT NULL,
aim varchar(20) NOT NULL,
yahoo varchar(20) NOT NULL,
signature mediumtext NOT NULL,
adminemail smallint(6) NOT NULL,
showemail smallint(6) NOT NULL,
invisible smallint(6) NOT NULL,
usertitle varchar(250) NOT NULL,
customtitle smallint(6) NOT NULL,
joindate int(10) unsigned NOT NULL,
cookieuser smallint(6) NOT NULL,
daysprune smallint(6) NOT NULL,
lastvisit int(10) unsigned NOT NULL,
lastactivity int(10) unsigned NOT NULL,
lastpost int(10) unsigned NOT NULL,
posts smallint(5) unsigned NOT NULL,
karma smallint(5) DEFAULT '10' NOT NULL,
karmaability tinyint(1) DEFAULT '1' NOT NULL,
karmashow tinyint(1) DEFAULT '1' NOT NULL,
timezoneoffset varchar(4) NOT NULL,
emailnotification smallint(6) NOT NULL,
buddylist mediumtext NOT NULL,
ignorelist mediumtext NOT NULL,
pmfolders mediumtext NOT NULL,
receivepm smallint(6) NOT NULL,
emailonpm smallint(6) NOT NULL,
pmpopup smallint(6) NOT NULL,
pmpopupfull smallint(6) NOT NULL,
avatarid smallint(6) NOT NULL,
options smallint(6) DEFAULT '15' NOT NULL,
birthday date DEFAULT '0000-00-00' NOT NULL,
maxposts smallint(6) DEFAULT '-1' NOT NULL,
startofweek smallint(6) DEFAULT '1' NOT NULL,
ipaddress varchar(20) NOT NULL,
referrerid int(10) unsigned NOT NULL,
nosessionhash smallint(6) NOT NULL,
showleftcolumn smallint(6) DEFAULT '1' NOT NULL,
starlevel varchar(5) NOT NULL,
starimg varchar(25) NOT NULL,
messagepopup tinyint(2) NOT NULL,
newsfader smallint(6) NOT NULL,
receivebulletin smallint(5) unsigned DEFAULT '1' NOT NULL,
inforum smallint(5) unsigned NOT NULL,
award tinytext NOT NULL,
startedthreads smallint(5) unsigned NOT NULL,
startedpubs smallint(5) unsigned NOT NULL,
forumviewset varchar(250) DEFAULT '219|2:98|2:22|2:252|2:120|2:128|2:61|2:' NOT NULL,
downloads text NOT NULL,
storep int(9),
insurance varchar(20),
custompageviews int(20) NOT NULL,
custompage mediumtext NOT NULL,
custompagename varchar(50) NOT NULL,
enablecustompage smallint(5) unsigned DEFAULT '1' NOT NULL,
bmallow smallint(6) NOT NULL,
bmwarn int(10) unsigned NOT NULL,
bmban int(10) unsigned NOT NULL,
bmreported int(6) unsigned NOT NULL,
timeonline int(10) NOT NULL,
money smallint(5) unsigned NOT NULL,
bank int(234) unsigned NOT NULL,
savemt int(10) unsigned NOT NULL,
warninglvl int(10) NOT NULL,
arcadepass int(255) NOT NULL,
journal smallint(6) NOT NULL,
PRIMARY KEY (userid),
KEY usergroupid (usergroupid),
KEY username (username),
KEY referrerid (referrerid),
KEY inforum (inforum),
KEY referrerid_2 (referrerid)
);

What can i delete and most importantly how can i delte em before running the query as obviously something here is causing the queries to rise beyond belief.

Cheers for any help.

Erwin

10-21-2002, 10:38 PM

Originally posted by Mr_P
Hope you can follow me on this one .

me tester board which is hack free is giving 25-27 queries as standard is that correct and thats with a clean install.

On what page? If it's index.php, it should be less than 20.

Now i take the user table from my boards database (nothing else just the user table to get members name/passwprd/email etc)

Now the queries rise to 91

On what page of your forum? What file are you running to get this query number? Showthread.php?

How is this possible with no hacks installed and is there hope for me to reduce the queries.I dont want all the members to have to re reg but i also dont want all them queries running esp when i aint installed any hacks.

Now remember this is a fresh install and all i want is the info from main board sucah as pass /email

but when i download the user table and run it as a query here is a list of what it runs.

DROP TABLE IF EXISTS user;
CREATE TABLE user (
userid int(10) unsigned NOT NULL auto_increment,
usergroupid smallint(5) unsigned NOT NULL,
username varchar(50) NOT NULL,
password varchar(50) NOT NULL,
email varchar(50) NOT NULL,
styleid smallint(5) unsigned NOT NULL,
parentemail varchar(50) NOT NULL,
coppauser smallint(6) NOT NULL,
homepage varchar(100) NOT NULL,
icq varchar(20) NOT NULL,
aim varchar(20) NOT NULL,
yahoo varchar(20) NOT NULL,
signature mediumtext NOT NULL,
adminemail smallint(6) NOT NULL,
showemail smallint(6) NOT NULL,
invisible smallint(6) NOT NULL,
usertitle varchar(250) NOT NULL,
customtitle smallint(6) NOT NULL,
joindate int(10) unsigned NOT NULL,
cookieuser smallint(6) NOT NULL,
daysprune smallint(6) NOT NULL,
lastvisit int(10) unsigned NOT NULL,
lastactivity int(10) unsigned NOT NULL,
lastpost int(10) unsigned NOT NULL,
posts smallint(5) unsigned NOT NULL,
karma smallint(5) DEFAULT '10' NOT NULL,
karmaability tinyint(1) DEFAULT '1' NOT NULL,
karmashow tinyint(1) DEFAULT '1' NOT NULL,
timezoneoffset varchar(4) NOT NULL,
emailnotification smallint(6) NOT NULL,
buddylist mediumtext NOT NULL,
ignorelist mediumtext NOT NULL,
pmfolders mediumtext NOT NULL,
receivepm smallint(6) NOT NULL,
emailonpm smallint(6) NOT NULL,
pmpopup smallint(6) NOT NULL,
pmpopupfull smallint(6) NOT NULL,
avatarid smallint(6) NOT NULL,
options smallint(6) DEFAULT '15' NOT NULL,
birthday date DEFAULT '0000-00-00' NOT NULL,
maxposts smallint(6) DEFAULT '-1' NOT NULL,
startofweek smallint(6) DEFAULT '1' NOT NULL,
ipaddress varchar(20) NOT NULL,
referrerid int(10) unsigned NOT NULL,
nosessionhash smallint(6) NOT NULL,
showleftcolumn smallint(6) DEFAULT '1' NOT NULL,
starlevel varchar(5) NOT NULL,
starimg varchar(25) NOT NULL,
messagepopup tinyint(2) NOT NULL,
newsfader smallint(6) NOT NULL,
receivebulletin smallint(5) unsigned DEFAULT '1' NOT NULL,
inforum smallint(5) unsigned NOT NULL,
award tinytext NOT NULL,
startedthreads smallint(5) unsigned NOT NULL,
startedpubs smallint(5) unsigned NOT NULL,
forumviewset varchar(250) DEFAULT '219|2:98|2:22|2:252|2:120|2:128|2:61|2:' NOT NULL,
downloads text NOT NULL,
storep int(9),
insurance varchar(20),
custompageviews int(20) NOT NULL,
custompage mediumtext NOT NULL,
custompagename varchar(50) NOT NULL,
enablecustompage smallint(5) unsigned DEFAULT '1' NOT NULL,
bmallow smallint(6) NOT NULL,
bmwarn int(10) unsigned NOT NULL,
bmban int(10) unsigned NOT NULL,
bmreported int(6) unsigned NOT NULL,
timeonline int(10) NOT NULL,
money smallint(5) unsigned NOT NULL,
bank int(234) unsigned NOT NULL,
savemt int(10) unsigned NOT NULL,
warninglvl int(10) NOT NULL,
arcadepass int(255) NOT NULL,
journal smallint(6) NOT NULL,
PRIMARY KEY (userid),
KEY usergroupid (usergroupid),
KEY username (username),
KEY referrerid (referrerid),
KEY inforum (inforum),
KEY referrerid_2 (referrerid)
);

What can i delete and most importantly how can i delte em before running the query as obviously something here is causing the queries to rise beyond belief.

Cheers for any help.

What do you mean by downloading the user table and running it as a query? Looking at your user table you have lots of custom hack columns, like the journal hack column, custom page column etc. So your database is not a clean install obviously.

Mr_P

10-21-2002, 11:23 PM

is a clean install Fresh install no hacks at all

the above is from the main board
The user table which i download seperate and re-add to the freshly installed board so members do not have to re-reg.

Queries show on main index page Erwin.

maybe im doing it wrong and its not possible to take the members on theri own from nother board and add them to a new install.I dont know these days LOL

Mr_P

10-21-2002, 11:26 PM

basically what im trying to do is just to get the members from my main board without all the hacks etc is this possible.
As when i do it and download the user table as this is where members are stored i seem to bring all that junk with me as listed above.And in doing so bring the queries.

Mr_P

10-21-2002, 11:36 PM

Sorry mods never noticed the PHP section does SQL problems as well.Can u move it there for me.
Thanks

Erwin

10-22-2002, 12:17 AM

Are you sure you are using an unhacked index.php? If you are, it doesn't matter about extra columns in the user table, the unhacked index.php won't be adding any additional queries.

Make sure the index.php is unhacked.

Mr_P

10-22-2002, 09:52 AM

yep im using an unhacked board nothing added to the board fresh copy.

All i do is copy over the user table and i get an automated 92 queries from it.

Mr_P

10-23-2002, 11:54 PM

is it possible for the user table to bring queries with it ?

Erwin

10-24-2002, 04:45 AM

Originally posted by Mr_P
is it possible for the user table to bring queries with it ?

No. When I uninstall hacks, I usually just take out the code in the PHP file and leave the extra tables and columns in my database (in case I reinstall the hacks). If the code doesn't query the database, there is no query. Which is why I am puzzled as to why you are getting so many queries with an unhacked index.php. Are you also using an unhacked global.php and phpincude template?

Mr_P

10-24-2002, 08:53 AM

Erwin cheers for responce.

Yes i am using unhacked global.php and index.php.

This is a toal fresh copy no hacks whatsoever.
All i do is grab the sql table called Users from main board.
I run it on the fresh board and it runs fine.
Now when i go to the forum the queries has suddenly rose to 92.
Now this is what has puzzled me - like u say the table s etc are still there and should`nt be causing any queries at all but they must be on mine as i would`nt have that many queries.
I personaly dont think there is a fix for it and may be me out of luck and everyone may have to register again but i only posted here on the very faintest offchance someone may know of a way round like it.
Anyway cheers for feedback.

Mr_P

10-24-2002, 08:55 AM

failing that is it possible to remove tables from the user table before i run it on a new board ?

such as for the ones for hacks which i dont have installed on the new board ?