Search and Browse not working #61
Comments
|
Yep, the cannot connect as user is because whatever user its currently trying to connect under is ether not a user to the server or your server isn't responding, most likely the first. |
|
see the user credentials is correct I have checked them over 10 times now although my server is acting up and not letting me login as root i will reformat and try again |
|
Apparently from your error message its not taking notice of the password and thus is not using it to authenticate itself with the database. Root is suppose to be able to login from localhost so its not not letting you log in, its just missing to include the password. |
|
na its obv a server error it lets me login when it wants to wiping the system now first time ive ever seen that problem and search on it |
|
i get the same error when i click browse on your website |
|
Yep, I'm aware except mine is giving the error that I'm lacking the database, I'm running in debug mode trying to figure it out. CDbCommand failed to execute the SQL statement: SQLSTATE[3D000]: Invalid catalog name: 1046 No database selected. The SQL statement executed was: SELECT count() FROM opbtorrents WHERE MATCH('@name tfirueidkw') ORDER BY weight() DESC, id DESC LIMIT 0, 20 OPTION ranker=expr('sum((4_lcs+2(min_hit_pos==1)+exact_hit)_user_weight)*1000+bm25 + (created_at - 1000000000) / (NOW() - 1000000000) * 100 + if(torrent_status=1,100,0)') So not the same error |
|
see all these errors lol i just want this to work so i can start coding user accounts and stuff |
|
I agree 100%, the faster we get to working on that the closer we are to having a torrent index with functionality. Once we have the user accounts then we can focus on uploading of torrents. |
|
Yeah theres so much that can be done to the future of file transferring |
|
done a fresh install and i get the same error passwords are correct |
|
Fresh install doesn't matter its something in the site code itself where it tells the database to tell it what is there. I'm not 100% sure where the actual problem spot is at this moment (in reality there shouldn't be one as I've seen a couple fully working replicas around) but it might be something really stupid we are missing. |
|
sphinx can connect to the db and its the same password in sphinx as the db same user and stuff aswell my thoughts are maybe its to do with the 2 lines of code you have to remove to get the install working at the moment |
|
Ok i found out what is causing my error it is sphinx i used the tutorial on here to set it up but there seems to be an error here using config file '/etc/sphinx/sphinx.conf'... ERROR: index 'opb_common': key 'path' not found. what is the key path and how do i fix it |
|
Try this. |
|
If someone managed to get openbay working (with its own database and sphinx) I'm interested (please post your config.php, sphinx.conf). |
for some reason search and browse do not work for me but recent does
http://raidercove.info
bellow is the error i get for a search
CDbException
CDbConnection failed to open the DB connection: SQLSTATE[HY000] [1045] Access denied for user ''@'localhost' (using password: NO)
/home/raider/protected/models/LSphinxDataProvider.php(174)
162 }
163 return $keys;
164 }
165
166 protected function calculateTotalItemCount()
167 {
168 $q = clone $this->query;
169
170 $q->setCountFieldOnly();
171 $sql = $q->build();
172 $total = 0;
173 try {
174 $recordsCount = Yii::app()->sphinx->cache($this->cacheTime)->createCommand($sql)->queryAll();
175 if (isset($recordsCount[0])) {
176 $total = $recordsCount[0]['count(*)'];
177 }
178 } catch (Exception $e) {
179 Yii::log('LSphinxDataProvider exception' . PHP_EOL . 'Message: ' . $e->getMessage() . 'Trace: ' . $e->getTraceAsString(), CLogger::LEVEL_ERROR);
180
181 if (YII_DEBUG) {
182 throw $e;
183 }
184 }
185
186 return $total > 9975 ? 9975 : $total;
Stack Trace
#0
Open Source Piracy is crap. #1
Browse not working, #2
Fixed error in render list #3
server requirements #4
– /home/raider/protected/models/LSphinxDataProvider.php(174): CModule->__get("sphinx")
169
170 $q->setCountFieldOnly();
171 $sql = $q->build();
172 $total = 0;
173 try {
174 $recordsCount = Yii::app()->sphinx->cache($this->cacheTime)->createCommand($sql)->queryAll();
175 if (isset($recordsCount[0])) {
176 $total = $recordsCount[0]['count(*)'];
177 }
178 } catch (Exception $e) {
179 Yii::log('LSphinxDataProvider exception' . PHP_EOL . 'Message: ' . $e->getMessage() . 'Trace: ' . $e->getTraceAsString(), CLogger::LEVEL_ERROR);
Array to string conversion #5
Please help me to deploy it with Xampp!!! #6
– /home/raider/protected/controllers/MainController.php(166): CDataProvider->getTotalItemCount()
161 $totalCount = 0;
162
163 if (! $searchModel->getErrors()) {
164 $torrentModel = LTorrent::model();
165 $torrents = $torrentModel->getSphinxDataProvider($searchModel);
166 $totalCount = $torrents->getTotalItemCount();
167
168 if (empty($totalCount)) {
169 $words = explode(' ', $searchModel->words);
170 if (count($words) > 1) {
171 $searchModel->words = $words;
fixed 'brining' to 'bringing' #7
unknown(0): MainController->actionSearch(null, null, null)
Fixed potential security issues #8
AHttpRequest::getUserHostAddress() is potentially unsafe #9
include(Controller.php): failed to open stream: No such file or directory #10
Blank page after installation #11
PHP Parse error: syntax error, unexpected ''torrents'' #12
CSV parsing #13
Removed /src/protected/vendor #14
Shared hosting on subdomains ? #15
Prevents unnecessary checking of var length #16
– /home/raider/public_html/index.php(13): CApplication->run()
08 $yii = DIR . '/../protected/vendor/yiisoft/yii/framework/' . (YII_DEBUG ? 'yii.php' : 'yiilite.php');
09 require_once (DIR . '/../protected/vendor/autoload.php');
10 require_once ($yii);
11
12 $config =(is_file('installer.php')) ? 'installer.php' : DIR . '/../protected/config/config.php';
13 Yii::createWebApplication($config)->run();
2014-12-23 22:16:10 Apache/2.4.10 (Unix) OpenSSL/1.0.1e-fips mod_bwlimited/1.4 Yii Framework/1.1.15
The text was updated successfully, but these errors were encountered: