Do's and Don'ts

JustMommies Tools

Baby Name Finder

FIND ALPHABETICALLYFIND BY ORIGIN
» Top Baby Boy Names » Top Baby Girl Names

Pregnancy Calendar

Track your pregnancy day by day.

Enter your due date:

Ovulation Calendar

Find your most fertile days.

Average cycle length:

From the Message Boards

CDbException

CDbException

CDbCommand failed to execute the SQL statement: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's and don'ts%' LIMIT 5' at line 4. The SQL statement executed was: SELECT t.firstpostid, t.threadid, t.title, t.replycount, t.dateline AS created, t.postuserid AS userid,
t.postusername AS name, f.title_clean as forum_title, f.forumid as forumid
FROM thread t INNER JOIN forum f ON f.forumid = t.forumid
WHERE f.showprivate = 0 AND f.password = '' AND visible = 1 AND taglist like '%do's and don'ts%' LIMIT 5

/var/www/html/sites/justmommies.com/redesign/releases/2017-11-14_10-00-54/app/lib/vendor/yiisoft/yii/framework/db/CDbCommand.php(543)

531         {
532             if($this->_connection->enableProfiling)
533                 Yii::endProfile('system.db.CDbCommand.query('.$this->getText().$par.')','system.db.CDbCommand.query');
534 
535             $errorInfo=$e instanceof PDOException ? $e->errorInfo : null;
536             $message=$e->getMessage();
537             Yii::log(Yii::t('yii','CDbCommand::{method}() failed: {error}. The SQL statement executed was: {sql}.',
538                 array('{method}'=>$method, '{error}'=>$message, '{sql}'=>$this->getText().$par)),CLogger::LEVEL_ERROR,'system.db.CDbCommand');
539 
540             if(YII_DEBUG)
541                 $message.='. The SQL statement executed was: '.$this->getText().$par;
542 
543             throw new CDbException(Yii::t('yii','CDbCommand failed to execute the SQL statement: {error}',
544                 array('{error}'=>$message)),(int)$e->getCode(),$errorInfo);
545         }
546     }
547 
548     /**
549      * Builds a SQL SELECT statement from the given query specification.
550      * @param array $query the query specification in name-value pairs. The following
551      * query options are supported: {@link select}, {@link distinct}, {@link from},
552      * {@link where}, {@link join}, {@link group}, {@link having}, {@link order},
553      * {@link limit}, {@link offset} and {@link union}.
554      * @throws CDbException if "from" key is not present in given query parameter
555      * @return string the SQL statement

Stack Trace

#1
+
 /var/www/html/sites/justmommies.com/redesign/releases/2017-11-14_10-00-54/app/controllers/ApiController.php(88): CDbCommand->query()
83 
84         if ( empty($data) || is_null($data)) {
85 
86             $connection = Yii::app()->dbvb;
87             $command=$connection->createCommand($sql);
88             $dataReader=$command->query();
89 
90             $data = array();
91             foreach($dataReader as $row) { 
92 
93                 $firstpostid = $row['firstpostid'];
#11
+
 /var/www/html/sites/justmommies.com/redesign/releases/2017-11-14_10-00-54/www/index.php(47): CApplication->run()
42 ini_set('display_errors', 1);
43 
44 require('./../app/lib/vendor/autoload.php');
45 require('./../app/lib/vb.php');
46 
47 Yiinitializr\Helpers\Initializer::create('./../app', 'main', array('env', 'dev'))->run();
48 
2017-11-23 06:43:27 Apache Yii Framework/1.1.17

» Check out the friendliest message board for moms and moms-to-be!

Dental Care During Pregnancy

By Maria T. Pepin

Is dental care safe during pregnancy? According to the American Dental Association (ADA), annual exams and routine cleanings during your pregnancy are perfectly safe and recommended. Make sure to let your dentist know that you are expecting. Some women may need dental procedures such as fillings, root
» Read more

Belly Piercings and Pregnancy

By JustMommies staff

Belly piercings have become quite popular. If you have a belly piercing you may have been told by well-meaning friends that you should remove your belly ring once you become pregnant. But do you really need to? A belly piercing that has completely healed is perfectly safe to keep during pregnancy. As
» Read more

Seafood and Pregnancy

By JustMommies staff

Seafood – edible freshwater fish and shellfish – offers many nutritional benefits. It’s high in protein, low in saturated fats and is rich in healthful omega-3 fatty acids. When you’re pregnant, seafood should be part of your diet, but there are some important factors to keep in mind when including
» Read more