Jump to content

gsurface

New Members
  • Posts

    3
  • Joined

  • Last visited

    Never

Profile Information

  • Gender
    Not Telling

gsurface's Achievements

Newbie

Newbie (1/5)

0

Reputation

  1. I was wondering if anyone here would be able to tell me what is wrong with the following MYSQL code below. When I try to run it in PHPMyAdmin, it gives me a #1064 error. [code] -- MySQL dump 10.9 -- -- Host: localhost    Database: blog_memes -- ------------------------------------------------------ -- Server version    4.1.16-standard /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES latin1 */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `debate` -- DROP TABLE IF EXISTS `debate`; CREATE TABLE `debate` (   `id` int(11) NOT NULL auto_increment,   `user_id` int(11) default NULL,   `position` int(11) default NULL,   `post_id` int(11) default NULL,   `comment` text,   `date_posted` datetime default NULL,   PRIMARY KEY  (`id`),   KEY `idx_debate_meme` (`post_id`),   KEY `idx_debate_user` (`user_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Table structure for table `post_cats` -- DROP TABLE IF EXISTS `post_cats`; CREATE TABLE `post_cats` (   `cat_title` varchar(100) default NULL,   `cat_desc` text,   `ID` int(11) NOT NULL auto_increment,   `lang` char(2) default 'es',   `feed` text,   PRIMARY KEY  (`ID`),   KEY `idx_cat_title` (`cat_title`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Table structure for table `post_comments` -- DROP TABLE IF EXISTS `post_comments`; CREATE TABLE `post_comments` (   `title` varchar(200) default NULL,   `content` text,   `user_id` int(11) default NULL,   `post_id` int(11) default NULL,   `date_posted` int(11) default NULL,   `ID` int(11) NOT NULL auto_increment,   PRIMARY KEY  (`ID`),   KEY `idx_post_comments` (`post_id`),   KEY `idx_user_comment` (`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Table structure for table `post_votes` -- DROP TABLE IF EXISTS `post_votes`; CREATE TABLE `post_votes` (   `post_id` int(11) default NULL,   `user_id` int(11) default NULL,   `date_voted` int(11) default NULL,   `ID` int(11) NOT NULL auto_increment,   `ip_address` varchar(15) default NULL,   PRIMARY KEY  (`ID`),   KEY `idx_post_votes_ip` (`ip_address`),   KEY `idx_post_votes_user_id` (`user_id`),   KEY `idx_post_votes_post_id` (`post_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Table structure for table `posts` -- DROP TABLE IF EXISTS `posts`; CREATE TABLE `posts` (   `title` varchar(200) default NULL,   `content` text,   `date_posted` int(11) default NULL,   `category` int(11) default NULL,   `url` varchar(200) default NULL,   `submitted_user_id` int(11) default NULL,   `ID` int(11) NOT NULL auto_increment,   `trackback` varchar(200) default NULL,   `date_promo` int(11) default NULL,   `lang` varchar(2) default 'es',   `clicks` int(11) default '0',   `rank` int(11) default '0',   `votes` int(11) NOT NULL default '0',   `is_micro_content` int(11) NOT NULL default '0',   `comments` int(11) NOT NULL default '0',   `icon` varchar(200) default NULL,   `debate_0` int(11) default '0',   `debate_neg` int(11) default '0',   `debate_pos` int(11) default '0',   `allows_debates` int(11) NOT NULL default '0',   `promoted` int(11) NOT NULL default '0',   PRIMARY KEY  (`ID`),   KEY `idx_post_dates` (`date_posted`),   KEY `idx_post_submiters` (`submitted_user_id`),   KEY `idx_post_cats` (`category`),   KEY `idx_post_url` (`url`),   KEY `idx_promo` (`date_promo`),   KEY `post_lang` (`lang`),   KEY `idx_post_rank` (`rank`),   KEY `idx_post_votes` (`votes`),   KEY `idx_prooted` (`promoted`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Table structure for table `tags` -- DROP TABLE IF EXISTS `tags`; CREATE TABLE `tags` (   `ID` int(11) NOT NULL auto_increment,   `tag` varchar(40) default NULL,   `lang` char(2) default 'es',   PRIMARY KEY  (`ID`),   KEY `idx_tags` (`tag`),   KEY `idx_tags_lang` (`lang`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Table structure for table `tags_posts` -- DROP TABLE IF EXISTS `tags_posts`; CREATE TABLE `tags_posts` (   `tag_id` int(11) NOT NULL default '0',   `post_id` int(11) NOT NULL default '0',   PRIMARY KEY  (`tag_id`,`post_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Table structure for table `tags_user` -- DROP TABLE IF EXISTS `tags_user`; CREATE TABLE `tags_user` (   `tag_id` int(11) NOT NULL default '0',   `user_id` int(11) NOT NULL default '0',   PRIMARY KEY  (`tag_id`,`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Table structure for table `users` -- DROP TABLE IF EXISTS `users`; CREATE TABLE `users` (   `username` varchar(100) default NULL,   `password` varchar(32) default NULL,   `email` varchar(200) default NULL,   `join_date` int(11) default NULL,   `admin` enum('0','1') default NULL,   `ID` int(11) NOT NULL auto_increment,   `website` varchar(200) default NULL,   `blog` varchar(200) default NULL,   `fullname` varchar(200) default NULL,   `persistent_session` varchar(64) default NULL,   `gravatar` varchar(32) default NULL,   `strong_pass` blob,   PRIMARY KEY  (`ID`),   KEY `idx_username` (`username`),   KEY `idx_user_email` (`email`),   KEY `idx_persist_session` (`persistent_session`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Table structure for table `users_profiles` -- DROP TABLE IF EXISTS `users_profiles`; CREATE TABLE `users_profiles` (   `user_id` int(11) default NULL,   `full_name` varchar(100) default NULL,   `website` varchar(200) default NULL,   `blogsite` varchar(200) default NULL,   `preferred_lang` char(2) default NULL,   `id` int(11) NOT NULL auto_increment,   `avatar` varchar(200) default NULL,   PRIMARY KEY  (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; [/code]
  2. I am getting an error using my board when sending mail using the sendmail in PHP. I submitted a trouble ticket to my hosting company. I have root access to the server. This is the responce they gave me: [!--quoteo--][div class=\'quotetop\']QUOTE[/div][div class=\'quotemain\'][!--quotec--] It seems in php.ini the file specified is /usr/sbin/sendmail -t -i but this is calling /usr/sbin/sendmail.real which cannot be found in the sbin. root@www [/var/log]# /usr/sbin/sendmail -t -i cannot open /usr/sbin/sendmail.real: No such file or directoryn at /usr/sbin/sendmail line 23. to resolve this issue you will need a valid path in my $mailprog = located in /usr/sbin/sendmail [/quote] I searched in that directory and I don't have that sendmail.real file. My question is how do I fix this problem? Do I just make my own sendmail.real file, if so, how? Thanks for your help guys. UPDATE: This is the responce I got from the tech support: [!--quoteo--][div class=\'quotetop\']QUOTE[/div][div class=\'quotemain\'][!--quotec--]It appears that you have corrected the issues with sendmail's symbolic link but it does not have the correct permissions and ownership right now. You will need to set this files mode to 2755 and the ownership to root:mailtrap.[/quote] My responce: How would I go about setting the file modes to 2755 and which files do I set to this value?
  3. Hi guys, I am trying to install Invision Gallery on my forums but it will not display the images properly because I do not have GD installed. Can anyone here offer me help on how to install GD 2.0. I have access to the server, it is a dedicated server, so I can use SSH if needed. Thanks in advanced.
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.