MySQL Error

Tai va atsisiunciau viena man reikalinga moda. Isirases gavau toki error:

The Error returned was:

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 '' at line 1

PhP kodas kur yra klaida:

$this->ipbdb->query("SELECT tag_meta_id, tag_text FROM {$this->ipbconfig['sql_tbl_prefix']}core_tags WHERE tag_prefix = '1' AND tag_meta_app = 'forums' ORDER BY tag_added DESC LIMIT {$this->config['sql_limit']}");

Ačiu iš anksto

Išprint'ink SQL užklausą ir pažiūrėk ar ji tinkamai sugeneruojama.

Ir kodėl "tag_prefix = '1'", o ne "tag_prefix = 1"? Juk 1 tai ne STRING tipo duomenys.

Pabandyk prefiksa lenteles {$this->ipbconfig['sql_tbl_prefix']}core_tags i hardkodinti, o {$this->config['sql_limit']} nurodyk atskirai kur nors aukščiau:

$sql_limit = {$this->config['sql_limit']};

O šiaip kaip jau sakė aukščiau tokiais būdais greičiausias sprendimais echo daryti užklausai ir patysi kad kažkas perduodama ne taip kaip reikia.

Va pilnas kodas. Dar nesusitvarkiau

// priešdėliai
	$topicPrefixes = array();
	if($this->config['topics_cache_time'] != 0) $prefixesCache = $this->getCache("prefixes");
	if($prefixesCache['time'] and (($prefixesCache['time'] + ($this->config['topics_cache_time'] * 60)) > time())) {
		$topicPrefixes = $prefixesCache['data'];
	} else {
		$this->ipbdb->query("SELECT tag_meta_id, tag_text FROM {$this->ipbconfig['sql_tbl_prefix']}core_tags WHERE tag_prefix = '1' AND tag_meta_app = 'forums' ORDER BY tag_added DESC LIMIT {$this->config['sql_limit']}");
		while($row = $this->ipbdb->get_row()) {
			$row = $this->encodeArray($row);
			$topicPrefixes[$row['tag_meta_id']] = $row['tag_text'];
		}
		if($this->config['topics_cache_time'] != 0) $this->setCache("prefixes", $topicPrefixes);
	}

	$topics = array();
	$ipb_settings = $this->getIpbSettings();
	foreach($this->getTopics() as $id=>$topic) {

		$showTopic = false;
		foreach($this->getAllowedForums() as $forumid) {
			if($topic['forum_id'] == $forumid) {
				$showTopic = true;
				break;
			}
		}

		if(count($this->config['exclude_forums']) > 0) {
			foreach($this->config['exclude_forums'] as $excluded_forum) {
				if($topic['forum_id'] == $excluded_forum) {
					$showTopic = false;
					break;
				}
			}
		}

		if(($this->config['show_closed'] != "1") and ($topic['state'] != "open")) $showTopic = false;

	if($showTopic) {

		$topic['start_date'] = $this->formatDate($this->config['create_date_format'], $topic['start_date']+($this->config['date_adjust']*60));
		$topic['last_post'] = $this->formatDate($this->config['lastpost_date_format'], $topic['last_post']+($this->config['date_adjust']*60));

		if(($topic['posts'] + 1) > $ipb_settings['hot_topic']) {
			$topic['hot'] = "1";
		} else {
			$topic['hot'] = "0";
		}