发表文章

[PHP] 更新后的 MySQL 问题 MySQL issue after update[Instagram-clone]

wazowski78 2017-10-9 33

嗨, 我的朋友,
我想我有一些麻烦后, 一些更新, 你能告诉我您使用的 MySQL 服务器版本请?我想我所有的问题都是因为 CPanel autoupdated 我的服务器:(
谢谢。

原文:

Hi my friend,
I think I have some troubles after some updates, can you tell me the MySQL server version you are using please? I think all my problems comes since CPanel autoupdated my servers :(
Thank you.

相关推荐
最新评论 (14)
yTakkar 2017-10-9
1

我的 MySQL 服务器版本: 10.1. 19-MariaDB-mariadb.org 二进制分布

原文:

My MySQL server version: 10.1.19-MariaDB - mariadb.org binary distribution

wazowski78 2017-10-9
2

我有一些问题, 我认为他们是关于服务器配置, 看:

[31-Aug-2017 14:20:33 Europe/Berlin] PHP Notice:  Undefined index: u in /Applications/MAMP/htdocs/cbsdk/profile.php on line 38
[31-Aug-2017 14:20:33 Europe/Berlin] PHP Notice:  Trying to get property of non-object in /Applications/MAMP/htdocs/cbsdk/config/class/universal.class.php on line 52
[31-Aug-2017 14:20:33 Europe/Berlin] PHP Notice:  Trying to get property of non-object in /Applications/MAMP/htdocs/cbsdk/config/class/universal.class.php on line 59
[31-Aug-2017 14:20:33 Europe/Berlin] PHP Notice:  Trying to get property of non-object in /Applications/MAMP/htdocs/cbsdk/config/class/universal.class.php on line 59
[31-Aug-2017 14:20:33 Europe/Berlin] PHP Notice:  Trying to get property of non-object in /Applications/MAMP/htdocs/cbsdk/config/class/universal.class.php on line 59
[31-Aug-2017 14:20:33 Europe/Berlin] PHP Notice:  Trying to get property of non-object in /Applications/MAMP/htdocs/cbsdk/config/class/universal.class.php on line 59
[31-Aug-2017 14:20:33 Europe/Berlin] PHP Notice:  Trying to get property of non-object in /Applications/MAMP/htdocs/cbsdk/config/class/universal.class.php on line 59
[31-Aug-2017 14:20:33 Europe/Berlin] PHP Notice:  Trying to get property of non-object in /Applications/MAMP/htdocs/cbsdk/config/class/universal.class.php on line 59
[31-Aug-2017 14:20:33 Europe/Berlin] PHP Notice:  Trying to get property of non-object in /Applications/MAMP/htdocs/cbsdk/config/class/universal.class.php on line 59
[31-Aug-2017 14:20:33 Europe/Berlin] PHP Notice:  Trying to get property of non-object in /Applications/MAMP/htdocs/cbsdk/config/class/universal.class.php on line 59
[31-Aug-2017 14:20:33 Europe/Berlin] PHP Notice:  Trying to get property of non-object in /Applications/MAMP/htdocs/cbsdk/config/class/universal.class.php on line 59
[31-Aug-2017 14:20:33 Europe/Berlin] PHP Notice:  Trying to get property of non-object in /Applications/MAMP/htdocs/cbsdk/config/class/universal.class.php on line 59
[31-Aug-2017 14:20:33 Europe/Berlin] PHP Notice:  Trying to get property of non-object in /Applications/MAMP/htdocs/cbsdk/config/class/universal.class.php on line 59
[31-Aug-2017 14:20:34 Europe/Berlin] PHP Notice:  Trying to get property of non-object in /Applications/MAMP/htdocs/cbsdk/config/class/universal.class.php on line 59
[31-Aug-2017 14:20:34 Europe/Berlin] PHP Notice:  Undefined offset: 0 in /Applications/MAMP/htdocs/cbsdk/config/class/avatar.class.php on line 20
[31-Aug-2017 14:20:34 Europe/Berlin] PHP Notice:  Trying to get property of non-object in /Applications/MAMP/htdocs/cbsdk/config/class/universal.class.php on line 59
[31-Aug-2017 14:20:34 Europe/Berlin] PHP Notice:  Trying to get property of non-object in /Applications/MAMP/htdocs/cbsdk/config/class/universal.class.php on line 59
[31-Aug-2017 14:20:34 Europe/Berlin] PHP Notice:  Trying to get property of non-object in /Applications/MAMP/htdocs/cbsdk/config/class/universal.class.php on line 59
[31-Aug-2017 14:20:34 Europe/Berlin] PHP Notice:  Trying to get property of non-object in /Applications/MAMP/htdocs/cbsdk/config/class/universal.class.php on line 59
[31-Aug-2017 14:20:34 Europe/Berlin] PHP Notice:  Trying to get property of non-object in /Applications/MAMP/htdocs/cbsdk/config/class/universal.class.php on line 59
[31-Aug-2017 14:20:34 Europe/Berlin] PHP Notice:  Trying to get property of non-object in /Applications/MAMP/htdocs/cbsdk/config/class/universal.class.php on line 59
[31-Aug-2017 14:20:34 Europe/Berlin] PHP Notice:  Trying to get property of non-object in /Applications/MAMP/htdocs/cbsdk/config/class/universal.class.php on line 59
[31-Aug-2017 14:20:34 Europe/Berlin] PHP Notice:  Trying to get property of non-object in /Applications/MAMP/htdocs/cbsdk/config/class/universal.class.php on line 59
[31-Aug-2017 14:20:34 Europe/Berlin] PHP Fatal error:  Uncaught PDOException: 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 'get FROM login WHERE user_id = NULL LIMIT 1' at line 1 in /Applications/MAMP/htdocs/cbsdk/config/class/universal.class.php:110
Stack trace:
#0 /Applications/MAMP/htdocs/cbsdk/config/class/universal.class.php(110): PDOStatement->execute(Array)
#1 /Applications/MAMP/htdocs/cbsdk/ajaxify/profile/profile_banner.php(89): universal->isOnline(NULL)
#2 /Applications/MAMP/htdocs/cbsdk/profile.php(76): include_once('/Applications/M...')
#3 {main}
  thrown in /Applications/MAMP/htdocs/cbsdk/config/class/universal.class.php on line 110
原文:

I have some problems, I think they are regarding the servers configurations, look:

[31-Aug-2017 14:20:33 Europe/Berlin] PHP Notice:  Undefined index: u in /Applications/MAMP/htdocs/cbsdk/profile.php on line 38
[31-Aug-2017 14:20:33 Europe/Berlin] PHP Notice:  Trying to get property of non-object in /Applications/MAMP/htdocs/cbsdk/config/class/universal.class.php on line 52
[31-Aug-2017 14:20:33 Europe/Berlin] PHP Notice:  Trying to get property of non-object in /Applications/MAMP/htdocs/cbsdk/config/class/universal.class.php on line 59
[31-Aug-2017 14:20:33 Europe/Berlin] PHP Notice:  Trying to get property of non-object in /Applications/MAMP/htdocs/cbsdk/config/class/universal.class.php on line 59
[31-Aug-2017 14:20:33 Europe/Berlin] PHP Notice:  Trying to get property of non-object in /Applications/MAMP/htdocs/cbsdk/config/class/universal.class.php on line 59
[31-Aug-2017 14:20:33 Europe/Berlin] PHP Notice:  Trying to get property of non-object in /Applications/MAMP/htdocs/cbsdk/config/class/universal.class.php on line 59
[31-Aug-2017 14:20:33 Europe/Berlin] PHP Notice:  Trying to get property of non-object in /Applications/MAMP/htdocs/cbsdk/config/class/universal.class.php on line 59
[31-Aug-2017 14:20:33 Europe/Berlin] PHP Notice:  Trying to get property of non-object in /Applications/MAMP/htdocs/cbsdk/config/class/universal.class.php on line 59
[31-Aug-2017 14:20:33 Europe/Berlin] PHP Notice:  Trying to get property of non-object in /Applications/MAMP/htdocs/cbsdk/config/class/universal.class.php on line 59
[31-Aug-2017 14:20:33 Europe/Berlin] PHP Notice:  Trying to get property of non-object in /Applications/MAMP/htdocs/cbsdk/config/class/universal.class.php on line 59
[31-Aug-2017 14:20:33 Europe/Berlin] PHP Notice:  Trying to get property of non-object in /Applications/MAMP/htdocs/cbsdk/config/class/universal.class.php on line 59
[31-Aug-2017 14:20:33 Europe/Berlin] PHP Notice:  Trying to get property of non-object in /Applications/MAMP/htdocs/cbsdk/config/class/universal.class.php on line 59
[31-Aug-2017 14:20:33 Europe/Berlin] PHP Notice:  Trying to get property of non-object in /Applications/MAMP/htdocs/cbsdk/config/class/universal.class.php on line 59
[31-Aug-2017 14:20:34 Europe/Berlin] PHP Notice:  Trying to get property of non-object in /Applications/MAMP/htdocs/cbsdk/config/class/universal.class.php on line 59
[31-Aug-2017 14:20:34 Europe/Berlin] PHP Notice:  Undefined offset: 0 in /Applications/MAMP/htdocs/cbsdk/config/class/avatar.class.php on line 20
[31-Aug-2017 14:20:34 Europe/Berlin] PHP Notice:  Trying to get property of non-object in /Applications/MAMP/htdocs/cbsdk/config/class/universal.class.php on line 59
[31-Aug-2017 14:20:34 Europe/Berlin] PHP Notice:  Trying to get property of non-object in /Applications/MAMP/htdocs/cbsdk/config/class/universal.class.php on line 59
[31-Aug-2017 14:20:34 Europe/Berlin] PHP Notice:  Trying to get property of non-object in /Applications/MAMP/htdocs/cbsdk/config/class/universal.class.php on line 59
[31-Aug-2017 14:20:34 Europe/Berlin] PHP Notice:  Trying to get property of non-object in /Applications/MAMP/htdocs/cbsdk/config/class/universal.class.php on line 59
[31-Aug-2017 14:20:34 Europe/Berlin] PHP Notice:  Trying to get property of non-object in /Applications/MAMP/htdocs/cbsdk/config/class/universal.class.php on line 59
[31-Aug-2017 14:20:34 Europe/Berlin] PHP Notice:  Trying to get property of non-object in /Applications/MAMP/htdocs/cbsdk/config/class/universal.class.php on line 59
[31-Aug-2017 14:20:34 Europe/Berlin] PHP Notice:  Trying to get property of non-object in /Applications/MAMP/htdocs/cbsdk/config/class/universal.class.php on line 59
[31-Aug-2017 14:20:34 Europe/Berlin] PHP Notice:  Trying to get property of non-object in /Applications/MAMP/htdocs/cbsdk/config/class/universal.class.php on line 59
[31-Aug-2017 14:20:34 Europe/Berlin] PHP Fatal error:  Uncaught PDOException: 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 'get FROM login WHERE user_id = NULL LIMIT 1' at line 1 in /Applications/MAMP/htdocs/cbsdk/config/class/universal.class.php:110
Stack trace:
#0 /Applications/MAMP/htdocs/cbsdk/config/class/universal.class.php(110): PDOStatement->execute(Array)
#1 /Applications/MAMP/htdocs/cbsdk/ajaxify/profile/profile_banner.php(89): universal->isOnline(NULL)
#2 /Applications/MAMP/htdocs/cbsdk/profile.php(76): include_once('/Applications/M...')
#3 {main}
  thrown in /Applications/MAMP/htdocs/cbsdk/config/class/universal.class.php on line 110
wazowski78 2017-10-9
3

"u" 的问题是从 URL _GET ("u"), 但它不存在..。

原文:

The problem with 'u' is in the line of $_GET['u'] from URL, but it is not there...

wazowski78 2017-10-9
4

因此, 主页加载, 但当我试图按我的个人资料或任何其他配置文件的网站显示 no_user 或404错误页。

原文:

So the home page loads, but when I try to press in my profile or any other profile the web shows the no_user or 404 error page.

wazowski78 2017-10-9
5

我正在寻找一个问题的舱口档案。因为当我把这个网址手动:

http://localhost/cbsdk/profile.php?u=diego

页面加载很好, 这些问题在配置文件页面和它的后裔, 我的意思是, 书签, 收藏夹, 图像等

我需要知道如何才能更改 htaccess 或使用配置文件页的代码。

原文:

I am looking for an issue with the hatches file. Because when I put manually this url:

http://localhost/cbsdk/profile.php?u=diego

The page loads well, these problems are in profile page and its descendants, I mean, bookmarks, favorites, images, etc

I need to know how I can change the htaccess or the code that uses the profile page.

yTakkar 2017-10-9
6

这是一个 DB 连接问题, 我想!

原文:

It's a DB connection problem, I think!!

wazowski78 2017-10-9
7

不!我认为这是其他的事情, 看, 如果我使用的网址:
http://localhost/cbsdk/profile.php?u=diego
它似乎工作, 但如果我使用默认的 url:
http://localhost/cbsdk/profile/diego
它不工作。

因此, 我有很多问题, 因为配置文件视图一直使用在很多部分。例如, 当我想访问左侧导航菜单中的照片时, 我得到了 url:
http://localhost/cbsdk/profile/diego?ask=photos
它不工作, 我需要类似的东西:
http://localhost/cbsdk/profile.php?u=diego&ask=photos
但这个网址不工作, 你能帮我一个工作的网址, 我怎么能得到相同的结果与另一。我是堆放在 ask 参数。我怎样才能从链接中调用它?

原文:

Nope! I think it is other thing, look, if I use the url:
http://localhost/cbsdk/profile.php?u=diego
It seems to work, but if I use the default url:
http://localhost/cbsdk/profile/diego
It does not work.

So I have a lot of problems because the profile view is used all along a lot of sections. For example when I want to get access to the photos from the left navigation menu, I get the url:
http://localhost/cbsdk/profile/diego?ask=photos
and it does not work, I would need something like:
http://localhost/cbsdk/profile.php?u=diego&ask=photos
but this url does not work, can you help me with a working url, how can I get the same result with another one. I am stacked at the ask parameter. How can I call it from a link?

yTakkar 2017-10-9
8

哦, 这是. htaccess 文件的问题。
它将与. htaccess 文件的这个回购!

原文:

Ohh, that's a problem with .htaccess file.
It will work with .htaccess file of this repo!!

wazowski78 2017-10-9
9

我已经检查了好几次, 我正在使用你的 htaccess 文件。但我不知道它是怎么回事:(

原文:

I have checked several times, I am using your htaccess file. But I can not figure out what is going wrong with it :(

yTakkar 2017-10-9
10

尝试再次安装/安装项目

原文:

Try to install/setup the project again

wazowski78 2017-10-9
11

我也做过好几次了。

原文:

I have done it several times too.

wazowski78 2017-10-9
12

我仍然认为是一个 htaccess 文件的问题, 我的意思是:
RewriteRule ^profile/ profile.php [QSA,NC,L]
似乎工作正常, 但:
RewriteRule ^profile/([a-zA-Z0-9._@\-]+)$ profile.php?u=$1 [QSA,NC,L]
不起作用。

原文:

I still thinking is a problem with the htaccess file, I mean, the:
RewriteRule ^profile/ profile.php [QSA,NC,L]
seems to work fine, but:
RewriteRule ^profile/([a-zA-Z0-9._@\-]+)$ profile.php?u=$1 [QSA,NC,L]
does not work.

yTakkar 2017-10-9
13

我搜索和检查你的问题几次, 并没有得到解决方案!

原文:

I googled and checked your problem several times and couldn't get the solution!!

wazowski78 2017-10-9
14

我知道, 我已经测试了几次重新启动服务器, 并没有..。我唯一能做的是恢复链接, 并试图使他们的工作没有 htaccess 的快捷方式。你能给我一些支持, 我试图使左导航照片部分的工作, 但我不能弄清楚如何做的 ' 问 ' 请求没有 htaccess 的捷径。

原文:

I know, I have tested several times restarting the server, and nothing... The only thing I can do is to revert the links and try to make them work without the htaccess shortcuts. Can you give me some support for that, I am trying to make the left nav photos section work, but I can not figure out how to do make the 'ask' request without the htaccess shortcut.

返回
发表文章
wazowski78
文章数
1
评论数
9
注册排名
60834