basicdb icon indicating copy to clipboard operation
basicdb copied to clipboard

basicdb Hatası

Open gokhandemirart opened this issue 5 years ago • 1 comments

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 '.login, account.password = ?.password, account.social_id = ?.social_id, account.' at line 1

INSERT INTO account.account SET account.login = :account.login, account.password = :account.password, account.social_id = :account.social_id, account.email = :account.email, account.web_ip = :account.web_ip, account.status = :account.status, account.create_time = :account.create_time

https://i.hizliresim.com/oXbJJb.jpg

@tayfunerbilen

gokhandemirart avatar May 11 '19 16:05 gokhandemirart

  Kod
	$this->sql .= ' SET ' . implode(', ', array_map(function ($item) {	
					if(strstr($item,'||PASSGDTR')){
						$item= str_replace("||PASSGDTR","",$item);
						return $item . "=PASSWORD(?)";
					}else{
						return $item . '= ?';
					}
                }, array_keys($data)));
				
			$newarray = (array_unique(array_values($data)));	
			
			$executeValue = $newarray;

Sorunu bu şekilde çözdüm. Eklediğim kısım BasicDB için bir sorun yaratır mı? @tayfunerbilen

gokhandemirart avatar May 11 '19 16:05 gokhandemirart