i have problem in mysql

[RikT]

thanks autotron for help now i have anther problem  the images do not appeared in forums pleas tell me how to solve that :)

At a guess I would say its a perms issue try chmodding the images and folder to 666 also make sure the ptahs to the images are correct

[Spidey]

thanks autotron for help now i have anther problem  the images do not appeared in forums pleas tell me how to solve that :)

[autotron]

ooops, shit sorry, wrong version :)
in /include look for cleanup.php remark this bit

Code Select Expand

//== Delete inactive user accounts
        $secs = 50*86400;
        $dt = (time() - $secs);
        $maxclass = UC_SYSOP;
        sql_query("DELETE FROM users WHERE parked='no' AND status='confirmed' AND class <= $maxclass AND last_access < $dt");
         //== Delete parked user accounts
         $secs = 175*86400; // change the time to fit your needs
         $dt = (time() - $secs);
         $maxclass = UC_SYSOP;
         sql_query("DELETE FROM users WHERE parked='yes' AND status='confirmed' AND class <= $maxclass AND last_access < $dt");
        //== Delete shout

[Spidey]

thanks guys i solved it it was my fault from the beginning i have anther question the system is deleting users i was having  45 now i have 21users pleas solution for that i do not want the system deleting user due inactivity

goto cleanup manage in admin cp turn off delete inactive user clean

i found Manual Cleanup but their is no delete inactive user on it

[autotron]

thanks guys i solved it it was my fault from the beginning i have anther question the system is deleting users i was having  45 now i have 21users pleas solution for that i do not want the system deleting user due inactivity

goto cleanup manage in admin cp turn off delete inactive user clean

[Spidey]

thanks guys i solved it it was my fault from the beginning i have anther question the system is deleting users i was having  45 now i have 21users pleas solution for that i do not want the system deleting user due inactivity

[MelvinMeow]

Are you running the command from within a database table selected?
It looks like your just running the command without selecting which database table to insert it into...

For example it should be

Code Select Expand

egyle002_egl2

[autotron]

how did you try to import the database?

[Spidey]

hello all i bought  shared hosting from Shinjiru when  i tried  to import the database
this appeared

Error

SQL query:

--
-- Database: `egyle002_egl2`
--
-- --------------------------------------------------------
--
-- Table structure for table `announcement_main`
--
CREATE TABLE IF NOT EXISTS `announcement_main` (
`main_id` int( 10 ) unsigned NOT NULL AUTO_INCREMENT ,
`owner_id` int( 10 ) unsigned NOT NULL DEFAULT '0',
`created` int( 11 ) NOT NULL DEFAULT '0',
`expires` int( 11 ) NOT NULL DEFAULT '0',
`sql_query` text NOT NULL ,
`subject` text NOT NULL ,
`body` text NOT NULL ,
PRIMARY KEY ( `main_id` )
) ENGINE = MYISAM DEFAULT CHARSET = latin1 AUTO_INCREMENT =1;

MySQL said: Documentation
#1046 - No database selecte 


i do not know what the problem is pleas help in this :D :D